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 = 1 

  and major_id = object_id(N'<<schema>>.<<table>>') 

  and name = 'MS_Description'