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]
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:
ok
Post a Comment
<< Home