Describing a table structure

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.
>.
>
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
> describing a table, without
>