RE: Describing a table structure

From: Jig Bhakta (JigBhakta_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Wed, 19 Jan 2005 19:13:04 -0800

is that the only way?

"Nigel Rivett" wrote:

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