使用SQL语句查询SQLServer字段的描述信息
SELECT sysobjects.name as TableName, syscolumns.name as ColumnName,
CONVERT(nvarchar(4000), sysproperties.[value]) AS ColumnDescription
FROM syscolumns INNER JOIN
sysproperties ON syscolumns.id = sysproperties.id AND
syscolumns.colid = sysproperties.smallid
INNER JOIN sysobjects ON sysobjects.id = syscolumns.id
WHERE (sysobjects.name='A_Test1_Test2_Test3' AND syscolumns.name = 'Nine_Ten')
其中'A_Test1_Test2_Test3'为表名,'Nine_Ten'为字段名.
CONVERT(nvarchar(4000), sysproperties.[value]) AS ColumnDescription
FROM syscolumns INNER JOIN
sysproperties ON syscolumns.id = sysproperties.id AND
syscolumns.colid = sysproperties.smallid
INNER JOIN sysobjects ON sysobjects.id = syscolumns.id
WHERE (sysobjects.name='A_Test1_Test2_Test3' AND syscolumns.name = 'Nine_Ten')
其中'A_Test1_Test2_Test3'为表名,'Nine_Ten'为字段名.