column description -- where is it in system tables 1

[vadimg]

hi Gurus.

When you create a ERD using Enterprise Manager's diagram utility -- you are able to see column descriptions. (You can also add column description when Designing table in Enterprise Manager.

Where in system tables is this value stored? (it's not in syscolumns where it would make the most sense....)

Thanks!

 

[vongrunt]

In table sysproperties.

------
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]

 

[JamesLean]

Also, for more info, look up fn_listextendedproperty in BOL, plus the link to "Property Management" at the bottom of the page.

--James