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_help returns detailed information about the entire table including the columns and constraints. Thanks to Brannon for his StackOverflow answer