Different SQL query to get details of every column in table with detai

1.	Different SQL query to get details of every column in table with details?
Answer» Different SQL QUERY to get details of every column in table with details? Below are the 3 MAIN query to find all details of every column of table (1)SELECT * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tbl_name' (2)SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.tbl_name') (3)SELECT o.Name, C.Name FROM sys.columns c JOIN sys.objects o ON o.object_id = c.object_id WHERE o.type = 'U' ORDER BY o.Name, c.Name

Discussion