select a.name,b.value
from syscolumns as a
left outer join sysproperties as b on a.id=b.id and b.smallid=a.colid
where a.id=object_id('表名')
select a.name,b.value
from syscolumns as a
left outer join sysproperties as b on a.id=b.id and b.smallid=a.colid
where a.id=object_id('表名')