Columns information and Extended properties

• lnadeau

  Grasshopper

  Points: 13

  More actions

  September 12, 2002 at 8:59 pm

  #158946

  I am currently using this store proc to get columns information : SP_MsHelpColumns because with this one I get the COL_LEN and COL_SCALE.

  I cannot have this information from INFORMATION_SCHEMA.Columns nor SP_Columns

  And I use fn_listextendedproperty to retreive extended properties.

  Is there a way to combine the SP_MsHelpColumns with the fn_listextendedproperty in one single SQL statement?

  Or What's the SQL statement behind SP_MsHelpColumns.

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  September 13, 2002 at 7:57 am

  #436488

  You can view the text of the stored proc in the master database.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn