Create table T1 (id int , name char (20)) GO EXEC sp_addextendedproperty 'MS_Description', ' ID', 'user', dbo, 'table', T1, 'column', idSELECT 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='text1' AND syscolumns.name = 'a')
GO
EXEC sp_addextendedproperty 'MS_Description', ' ID', 'user', dbo, 'table', T1, 'column', idSELECT 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='text1' AND syscolumns.name = 'a')
UserTable是你的表名
UserField是你的字段名
现在不是再用记事本来写程序的年代了,了解就行