>When creating table columns ( through the IDE ), one of the optional paramters that can be entered is the column's "Description". Where is the "Description" data for the column stored and is it possible to query it? If so, how?
>
>I have tried sp_columns and sp_columns_rowset and neither produces this column data. The output sp_columns_rowset contains a "Description" column but the values in it are always NULL.
>
>Thanks,
>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