How do I view table information such as constraints?

19/09/2007, 09h40

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 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 me?

19/09/2007, 12h24

EXEC sp_ 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 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 me?

26/09/2007, 09h43

On Sep 19, 11:24 pm, "Roy Harvey (MVP)" <roy_har...@snet.net> wrote:
> EXEC sp_ 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 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 me?- Hide quoted text -
>
> - Show quoted text -

Thanks, thats what I was after.

19/09/2007, 09h40	#1 (permalink)
ben_cameron00@hotmail.com Messages: n/a Hébergeur:	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 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 me?

19/09/2007, 12h24	#2 (permalink)
Roy Harvey (MVP) Messages: n/a Hébergeur:	Re: How do I view table information such as constraints? EXEC sp_ 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 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 me?

26/09/2007, 09h43	#3 (permalink)
Sems Messages: n/a Hébergeur:	Re: How do I view table information such as constraints? On Sep 19, 11:24 pm, "Roy Harvey (MVP)" <roy_har...@snet.net> wrote: > EXEC sp_ 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 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 me?- Hide quoted text - > > - Show quoted text - Thanks, thats what I was after.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email