Describe table in SQL Server 2005 - Equivalent of Oracle Describe command

Submitted by northben on Tue, 01/20/2009 - 10:05

Categories:

In Oracle, the describe command shows the metadata for a table in your SQL database. The equivalent command in Microsoft SQL Server 2005 (and 2008, probably) is sp_columns. Try using sp_columns
to find out the data type of each column, along with other useful information about your tables.