PHWinfo - Afficher un message - How do I view table information such as constraints?

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.

26/09/2007, 09h43	#3
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.