Seeking System Table for Comments 1

[MKVAB]

Anybody know which system table contains the actual comments for tables? I can find stored procedure text and column defaults in syscomments, but not the actual attribute's comments.

Ideas?

Thanks!
-MK

 

[vongrunt]

If you think about column comments, these are extended properties - table sysproperties, sql_variant data. Also see fn_listextendedproperty() function in BOL.

 

[MKVAB]

Thank you!!!
Exactly what I was looking for!


For others: here's a query to grab the column and table name.

select sysobjects.name TableName,
       syscolumns.name ColumnName,
       sysproperties.Value ColumnComment
from   syscolumns
       inner join sysproperties
          on syscolumns.id = sysproperties.id
         and syscolumns.colid = sysproperties.smallid
       inner join sysobjects
          on syscolumns.id = sysobjects.id