Describing a table structure

From: Mark Laffey (mark.laffey_at_littlewoodsgaming.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 08:10:47 -0800

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.
>.
>

Relevant Pages

  • RE: Describing a table structure
    ... "Mark Laffey" wrote: ... > I too had the same problem, coming from an Oracle ... To descibe the table employees in the Northwind ...
    (microsoft.public.sqlserver.mseq)
  • Re: Looking for oracle/sql tutorials and advice
    ... I'm teaching myself oracle and I am looking for some easy to follow ... step by step tutorials on oracle and sql. ... employees, and also for departments. ... I'm not sure this has much to do with foreign keys. ...
    (comp.databases.oracle.misc)
  • Looking for oracle/sql tutorials and advice
    ... I'm teaching myself oracle and I am looking for some easy to follow ... step by step tutorials on oracle and sql. ... Working with foreign keys. ... employees, and also for departments. ...
    (comp.databases.oracle.misc)
  • Re: New Topic - OLAP Server Performance etc (moved on from "Re: Hyperion Vs EPB and OFA")
    ... (then on his Rockport sabbatical from Oracle) ... I guess it's no longer possible for employees of ... which shows that Michael used to know that Applix had submitted TM1 to ...
    (comp.databases.olap)
  • Re: Multiple datasets in one dataset
    ... The client gets in a time out ... So it looks like Oracle never returns. ... LEFT OUTER JOIN employees e ... This is equivalent to the following pre-Oracle9i outer join notation: ...
    (comp.databases.oracle.misc)