krishna reddy-267698
Old Hand
Points: 380
More actions
October 31, 2005 at 1:29 pm
#169570
May i know if there is anyother way to find the metadata of a table other than using
sp_help.......sp_help is apparently giving me wrong results!!!!
thank you
Ray M
SSC-Insane
Points: 21093
October 31, 2005 at 4:18 pm
#601447
Look for information_schema in books online.
It describes how you can get to that data using microsoft created logical views.
such as information_schema.columns.
select *
from information_schema.columns
where table_Name = 'mytable'
GL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply