Home › Blogs › northben's blog

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

Tue, 01/20/2009 - 10:05 — northben
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.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options