Describing Tables in MSSQL

There are 2 particularly good stored procedures in SQL Server for getting information about a particular table.

sp_columns returns detailed information about each of the columns in the table. Thanks to Vincent Ramdhanie StackOverflow answer

sp_columns @tablename

sp_help returns detailed information about the entire table including the columns and constraints. Thanks to Brannon for his StackOverflow answer

sp_help @tablename