程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SqlServer數據庫 >> 關於SqlServer >> 獲取SQL Server數據字典的經典SQL語句

獲取SQL Server數據字典的經典SQL語句

編輯:關於SqlServer


本文主要介紹了一個獲取SQL Server數據字典的經典SQL語句,大家可以根據各自的實際情況對這段語句進行相應的修改。

SELECT sysobjects.name AS [table], syspropertIEs.[value] AS 表說明,
syscolumns.name AS field, propertIEs.[value] AS 字段說明, systypes.name AS type,
syscolumns.length, ISNULL(COLUMNPROPERTY(syscolumns.id, syscolumns.name,
'Scale'), 0) AS 小數位數, syscolumns.isnullable AS isnull,
CASE WHEN syscomments.text IS NULL
THEN '' ELSE syscomments.text END AS [Default],
CASE WHEN COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'IsIdentity')
= 1 THEN '√' ELSE '' END AS 標識, CASE WHEN EXISTS
(SELECT 1
FROM sysobjects
WHERE xtype = 'PK' AND name IN
(SELECT name
FROM sysindexes
WHERE indid IN
(SELECT indid
FROM sysindexkeys
WHERE id = syscolumns.id AND colid = syscolumns.colid)))
THEN '√' ELSE '' END AS 主鍵
FROM syscolumns INNER JOIN
sysobjects ON sysobjects.id = syscolumns.id INNER JOIN
systypes ON syscolumns.xtype = systypes.xtype LEFT OUTER JOIN
sysproperties properties ON syscolumns.id = propertIEs.id AND
syscolumns.colid = propertIEs.smallid LEFT OUTER JOIN
sysproperties ON sysobjects.id = syspropertIEs.id AND
syspropertIEs.smallid = 0 LEFT OUTER JOIN
syscomments ON syscolumns.cdefault = syscomments.id
WHERE (sysobjects.xtype = 'U')-

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