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?

• Next in forum: Market News. QSC partners with Yellowfin Business Intelligence
• Prev in forum: Re: Comparing databases
• Thread view: Re: How do I view table information such as constraints?

[Reply to this message]