SQL server--querying databases, tables, columns, and more

I. Querying the database (Sys.databases--select *from sys.databases where name= ' < database name > ')

Select *fromwhere name='MyDatabase'

Second, query table (sysobjects--select *from sysobjects where id=object_id (' < table name > '))

Select *fromwhere id=object_id ('studentsinfo')

Third, query column (Syscolumns--select COUNT (*) from syscolumns where name= ' < column name > ' and id=object_id (' < table name > '))

Select  from where name='sname' and id=object_id ('studentsinfo ')

Iv. querying a stored procedure or view (SELECT * from sysobjects where name= ' < view or stored procedure name > ' and type = ' p/v ')

SQL server--querying databases, tables, columns, and more