Posted by Sems on 09/26/07 08:43

On Sep 19, 11:24 pm, "Roy Harvey (MVP)" <roy_har...@snet.net> 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.

• Next in forum: a small SQL Puzzle
• Prev in forum: Re: Moving DB from one drive to another
• Thread view: Re: How do I view table information such as constraints?

[Reply to this message]