How do I view table information such as constraints?

#1

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?

#2

EXEC sp_help tablename

Roy Harvey
Beacon Falls, CT

On Wed, 19 Sep 2007 01:40:49 -0700, ben_cameron00 (AT) hotmail (DOT) com wrote:

Quote:

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?

#3

On Sep 19, 11:24 pm, "Roy Harvey (MVP)" <roy_har... (AT) snet (DOT) net> wrote:

Quote:

EXEC sp_help tablename

Roy Harvey
Beacon Falls, CT

On Wed, 19 Sep 2007 01:40:49 -0700, ben_camero... (AT) hotmail (DOT) 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I view table information such as constraints?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

How do I view table information such as constraints? - 09-19-2007 , 03:40 AM

Re: How do I view table information such as constraints? - 09-19-2007 , 06:24 AM

Re: How do I view table information such as constraints? - 09-26-2007 , 03:43 AM