导出Sql Server数据字典的语句(收藏)
摘要:
1 导表的: SELECT TOP (100) PERCENT CASE WHEN a.colorder = 1 THEN d .name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS 字段序号, a.name AS 字段名, CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIdentity') = 1 THEN '√' 阅读全文
posted @ 2009-12-04 16:28 白亚伟 阅读(352) 评论(0) 推荐(0) 编辑