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