SQL2000:

SELECT B.name as 字段名,A.[value] as 注释
FROM sysproperties A INNER JOIN
      syscolumns B ON b.colid = A.smallid AND A.id = B.id
WHERE (B.id = OBJECT_ID('表名称'))

SQL2005:

select * from fn_listextendedproperty('MS_Description',   'user',   'dbo',   'table',   '表名称'',   'column',   default)
注:次方法只能取出有注释的字段,如果指定表没有注释,则此方法不能获取到任何记录

评论