• I added this:

    select

    SO.name as 'table', SC.name as field,

    ST.name as datatype, SC.length as 'size',

    COALESCE

    (sp.value,df.Comment,'') as 'description'

    from

    syscolumns SC

    inner

    join sysobjects SO on SC.id = SO.id

    inner

    join systypes ST on ST.xusertype = SC.xusertype

    left

    join sysproperties sp on sp.id = so.id and sp.smallid = SC.colid and sp.name = 'MS_Description'

    left

    outer join doc_fields df on df.tablename = so.name and df.fieldname = SC.name

    where

    SO.xtype = 'U' and SO.status > 0

    order

    by SO.name, SC.colorder

    Now it looks into the extended properties or my table.

    ATBCharles Kincaid