Microsoft SQL Server doesn’t seem to have a describe command, and usually, folks seem to want to build a stored procedure to get the describe-like behaviors. However, this is not always practical based on your permissions. So, the simple SQL below will provide describe-like the information in a pinch. You may want to dress it up a bit, but I usually just use it raw, as shown below, by adding the table name.
Describe T-SQL Equivalent
Select *
From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = ‘<<TABLENAME>>’; |