Friday, June 11, 2010

Find all Database in sql server 2005

select * from sys.databases


select * from sys.tables



To see all the column of table



select * from sys.all_columns where [object_id]= OBJECT_ID (N'dbo.emp')//Emp is table name
 

No comments:

Post a Comment

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...