SELECT 表名=case when a.colorder=1 then d.name else '' end, 字段名=a.name, 字段说明=isnull(g.[value],'') FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' left join sysproperties g on a.id=g.id and a.colid=g.smallid where d.name='userlist' and a.name='userid' order by a.id,a.colorder
以上出处:SQL版的邹健回答别人时的代码....
显示是 <Binary> 怎么让它显示中文
SELECT sysobjects.name as TABLE_NAME ,syscolumns.name AS COLUMN_NAME ,isnull(sysproperties.[value],'') as COLUMN_COMMNET FROM sysobjects inner join syscolumns ON ( sysobjects.id = syscolumns.id and sysobjects.id=object_id('t1') ) left outer join sysproperties ON ( syscolumns.id = sysproperties.id and syscolumns.colid=sysproperties.smallid )
表名=case when a.colorder=1 then d.name else '' end,
字段名=a.name,
字段说明=isnull(g.[value],'')
FROM syscolumns a
inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
left join sysproperties g on a.id=g.id and a.colid=g.smallid
where d.name='userlist' and a.name='userid'
order by a.id,a.colorder
,syscolumns.name AS COLUMN_NAME
,isnull(sysproperties.[value],'') as COLUMN_COMMNET
FROM sysobjects inner join syscolumns
ON (
sysobjects.id = syscolumns.id
and sysobjects.id=object_id('t1')
)
left outer join sysproperties
ON (
syscolumns.id = sysproperties.id
and syscolumns.colid=sysproperties.smallid
)