本文主要介紹了一個獲取SQL Server數(shù)據(jù)字典的經(jīng)典SQL語句，大家可以根據(jù)各自的實(shí)際情況對這段語句進(jìn)行相應(yīng)的修改。

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 小數(shù)位數(shù), 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 標(biāo)識, CASE WHEN EXISTS(SELECT 1FROM sysobjectsWHERE xtype = 'PK' AND name IN(SELECT nameFROM sysindexesWHERE indid IN(SELECT indidFROM sysindexkeysWHERE id = syscolumns.id AND colid = syscolumns.colid))) THEN '√' ELSE '' END AS 主鍵FROM syscolumns INNER JOINsysobjects ON sysobjects.id = syscolumns.id INNER JOINsystypes ON syscolumns.xtype = systypes.xtype LEFT OUTER JOINsysproperties properties ON syscolumns.id = properties.id AND syscolumns.colid = properties.smallid LEFT OUTER JOINsysproperties ON sysobjects.id = sysproperties.id AND sysproperties.smallid = 0 LEFT OUTER JOINsyscomments ON syscolumns.cdefault = syscomments.idWHERE (sysobjects.xtype = 'U')