Microsoft SQL Server doesn’t seem have a describe command and usually, folks seem to want to build a stored procedure to get the describe behaviors. However, this is not always practical based on your permissions. So, the simple SQL below will provide describe like 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
Where TABLE_NAME = ‘<<TABLENAME>>’;