• The SysProperties Table has the description.

    the name should be 'MS_Description'

    Here I have a sample code

    select O.Name [Table_name], c.name [Column_Name],

    p.Value [description]

    From dbo.SysObjects O,

    dbo.SysColumns C Left Outer Join

    (select id, smallid, name, Value from dbo.SysProperties

    Where Name = 'MS_Description') P

    On P.id = c.id and P.smallid = C.Colid

    Where O.id = C.id and ObjectProperty(O.id, 'ISUSERTABLE')=1

    Order By O.name, c.colid

    If you have different users owning tables with same file names You may have to add the table_schema too.

     
     

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/