SELECT sc.name 字段名,sp.value 描述值 FROM syscolumns sc INNER JOIN sysproperties sp ON sp.ID=sc.ID AND sp.smallid=sc.colid WHERE sc.ID=object_id('表名')
补充一个详细点的 select syscolumns.name as 字段名称, systypes.name as 数据类型, syscolumns.length as 长度, syscolumns.isnullable,sysproperties.value as 字段描述 from syscolumns,systypes,sysproperties where syscolumns.id=object_id('表名') and sysproperties.id=object_id('表名') and syscolumns.colid=sysproperties.smallid and systypes.xtype=syscolumns.xtype
----显示列的描述值 SELECT value FROM ::FN_LISTEXTENDEDPROPERTY('MS_Description','user','dbo','table','表名','column','列名') ----显示列的所有属性 SELECT value FROM ::FN_LISTEXTENDEDPROPERTY(NULL,'user','dbo','table','表名','column','列名')
FROM syscolumns sc
INNER JOIN sysproperties sp
ON sp.ID=sc.ID AND sp.smallid=sc.colid
WHERE sc.ID=object_id('表名')
select syscolumns.name as 字段名称,
systypes.name as 数据类型,
syscolumns.length as 长度,
syscolumns.isnullable,sysproperties.value as 字段描述
from
syscolumns,systypes,sysproperties
where
syscolumns.id=object_id('表名') and sysproperties.id=object_id('表名') and
syscolumns.colid=sysproperties.smallid and systypes.xtype=syscolumns.xtype
SELECT value FROM ::FN_LISTEXTENDEDPROPERTY('MS_Description','user','dbo','table','表名','column','列名')
----显示列的所有属性
SELECT value FROM ::FN_LISTEXTENDEDPROPERTY(NULL,'user','dbo','table','表名','column','列名')