extended properties storage

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 20, 2002 at 11:07 am

  #151727

  does anybody know where does sql server store the extended properties for tables and for columns?

  for example, i created an extended property called "caption" for a column in a table. which system table is that caption-value stored in?

  thanks in advance

  Billy

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  August 20, 2002 at 11:15 am

  #434868

  sysproperties

  Steve Jones

  sjones@sqlservercentral.com

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

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 20, 2002 at 11:23 am

  #434869

  thanks...

  the sysproperties table was not in the SQL Server 2000 System Table map I was using...

  the system table map I got it from:

  http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp

  Billy

• Phil Factor

  SSC-Insane

  Points: 20244

  More actions

  November 24, 2009 at 6:57 am

  #1083422

  Now (2005/2008)

  sys.extended_properties

  http://msdn.microsoft.com/en-us/library/ms177541.aspx

  Best wishes,
  Phil Factor