Friday, October 22, 2010

Sql - search for column comments

Technical reference - an easy way to query the system tables to search for column comments.

select *
from sys.extended_properties
where class =
  and major_id = object_id(N'<<schema>>.<<table>>') 
  and name = 'MS_Description'

No comments:

Post a Comment