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

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.