RE: Describing a table structure

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 01/20/05 

Date: Wed, 19 Jan 2005 17:59:02 -0800

Do you mean
sp_help tblname

"Jig Bhakta" wrote:

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