Posted by Roy Harvey (MVP) on 09/19/07 11:24

EXEC sp_help tablename

Roy Harvey
Beacon Falls, CT

On Wed, 19 Sep 2007 01:40:49 -0700, ben_cameron00@hotmail.com wrote:

>I remember once using a command in Query Analyser that gave me all the
>information about a table. It showed details about the columns,
>constraints, keys, indexes etc.
>
>I can't remember how I did this? Can anyone help me?
>
>It could of been a stored proc that I called or a query on the system
>tables.
>
>I do know that it was very simple to do and it was executed in Query
>Analyser.
>
>Can anyone help me?

[Back to original message]