Friday, June 24, 2011

Describe the structure of a table in SQLServer

You can get the structure of a table on SQL Server using the query

exec sp_help 'tablename'