metadata of a table

• 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

  More actions

  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