Hi Borissov,
Just FYI, apparently this will not work in SQL 2000, complaining that sys.extended_properties was not an object.
After tinkering with Sergey's solution ( via Naomi ), I was able to retrieve the data.
Bill
>
>This works on SQL 2005 (I can't test it right now on SQL 2000)
>
>SELECT *
> FROM sys.extended_properties
>LEFT JOIN INFORMATION_SCHEMA.Columns
>ON OBJECT_NAME(Major_Id) = INFORMATION_SCHEMA.Columns.Table_Name AND
> Minor_Id = INFORMATION_SCHEMA.Columns.Ordinal_Position
>WHERE Class = 1
>
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.