摘要: --获取库中的所有字段的描述SELECT [Table Name] = OBJECT_NAME(c.object_id), [Column Name] = c.name, [Description] = ex.value FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTPROPERTY(c.object 阅读全文
posted @ 2011-04-13 14:19 笑萧亦然 阅读(190) 评论(0) 推荐(0) 编辑