sp_help tablename

Using the following syntax will provide details on a table.

Syntax:  sp_help 'tablename'

Example: sp_help 'authors'


This system procedure is most useful in obtaining details of columns within a table.  Their names and datatypes.