随笔分类 -  数据库 - DataBase

查询数据库表字段的说明
摘要:--查询语句SELECT [Table Name] = OBJECT_NAME(col.object_id), [Column Name] = col.name, [Description] = ex.value FROM sys.columns col LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = col.object_id AND ex.minor_id = col.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(col.o. 阅读全文
posted @ 2011-12-27 17:54 Robin Yang 阅读(350) 评论(0) 推荐(0)