怎么取表的备注信息?
同题

------解决方案--------------------
select case when c.colid=1 then object_name(c.id) else ' ' end as 表名
,p.value as 备注
from syscolumns c
inner join systypes t on c.xusertype=t.xusertype
left join sysproperties p on c.id=p.id and c.colid = p.smallid
left join syscomments m on c.cdefault=m.id
where objectproperty(c.id, 'IsUserTable ')=1
and object_name(c.id) = '表名 '