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