RE: Describing a table structure
From: Jig Bhakta (JigBhakta_at_discussions.microsoft.com)
Date: 02/02/05
- Next message: Hugo Kornelis: "Re: Union Query syntax"
- Previous message: Hugo Kornelis: "Re: Data style?"
- In reply to: Mark Laffey: "Describing a table structure"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Feb 2005 13:03:02 -0800
Thanks.
"Mark Laffey" wrote:
> Hi Jig,
> I too had the same problem, coming from an Oracle
> background. The SQL Server equivalent of 'desc' is
> sp_help, followed by the table name in single quotes.
> e.g. To descibe the table employees in the Northwind
> database:
>
> Use Northwind
> sp_help 'employees'
>
> This give the same info as the Oracle 'desc'
>
> Mark
>
> >-----Original Message-----
> >Hi,
> >
> >I would like to know the syntax in MS SQL 2K for
> describing a table, without
> >having to expand everything in the object browser.
> >
> >I know in Oracle it is: desc <table_name>;
> >
> >Thanks,
> >
> >Jig.
> >.
> >
>
- Next message: Hugo Kornelis: "Re: Union Query syntax"
- Previous message: Hugo Kornelis: "Re: Data style?"
- In reply to: Mark Laffey: "Describing a table structure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
