How do I view table information such as constraints?

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?

Re: How do I view table information such as constraints?

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?

Re: How do I view table information such as constraints?

On Sep 19, 11:24 pm, "Roy Harvey (MVP)" wrote:
> EXEC sp_help tablename
>
> Roy Harvey
> Beacon Falls, CT
>
>
>
> On Wed, 19 Sep 2007 01:40:49 -0700, ben_camero...@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?- Hide quoted text -
>
> - Show quoted text -

Thanks, thats what I was after.