Finding MetaData of table using anything other than sp_help

• krishna reddy-267698

  Old Hand

  Points: 380

  More actions

  October 31, 2005 at 1:29 pm

  #169339

  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

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  October 31, 2005 at 1:40 pm

  #601413

  Query system tables.

  _____________
  Code for TallyGenerator

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  October 31, 2005 at 1:40 pm

  #601412

  sp_columns

  
  
  A.J.
  DBA with an attitude

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  October 31, 2005 at 1:53 pm

  #601416

  select * from INFORMATION_SCHEMA.columns

  SQL = Scarcely Qualifies as a Language