Monday, June 06, 2005

Obtaining all the fields in a table

Many times we need to know the name of an field from Query Analyzer and we have open
Enterprise Manager with another task with which sometimes is difficult open another MMC->Enterprise Manager.

Forget to do this:

sp_help [table]

And try this query:

Select top 0 * from [table]


So this way you obtain each of the fields, just the name.

1 Comments:

Anonymous Anonymous said...

ok

12:13 AM  

Post a Comment

<< Home