程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> 其他數據庫知識 >> 更多數據庫知識 >> mssql2005,2008導出數據字典實現方法

mssql2005,2008導出數據字典實現方法

編輯:更多數據庫知識

在你要導出數據字典的數據空中右鍵,新建查詢,執行如下代碼即可
復制代碼 代碼如下:
SELECT
(case when a.colorder=1 then d.name else '' end)表名,d.xtype as 表類型,
a.colorder 字段序號,
a.name 字段名,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) 標識,
(case when (SELECT count(*)
FROM sysobjects
WHERE (name in
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid in
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid in
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 then '√' else '' end) 主鍵,
b.name 類型,
a.length 占用字節數,
COLUMNPROPERTY(a.id,a.name,'PRECISION') as 長度,
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as 小數位數,
(case when a.isnullable=1 then '√'else '' end) 允許空,
isnull(e.text,'') 默認值,
isnull(g.[value],'') AS 字段說明
FROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
on a.id=d.id and d.xtype in ('U','V') and d.name<>'dtproperties'
left join syscomments e
on a.cdefault=e.id
left join sys.extended_properties g
on a.id=g.major_id AND a.colid = g.major_id
order by a.id,a.colorder

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved