select 

o.name  tableName,

c.name  columnName,

t.name  columnType,

p.value  columnDescription,

c.length columnLength,

c.isnullable  isnull,

(select text from syscomments where id=c.cdefault) columnDefaultValue

from  

sysobjects o, 

syscolumns c,

sys.extended_properties p,

systypes t

where o.id=c.id

and p.major_id=c.id 

and p.minor_id=c.colid  

and c.xusertype=t.xusertype

and o.type='u'

and p.name='MS_Description'  

and o.name='netwingcrm_company'

运行结果