SQL server table Describe (DESC) equivalent

Technology -SQL Server Table Describe (DESC) Equivalent

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

Related References

%d bloggers like this: