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
 | |