一个获取SQL Server数据字典的经典SQL语句


本文主要介绍了一个获取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')



相关阅读:
讲解Oracle数据库B-tree索引
CSS3的简单又实用的3个属性
javascript 学习笔记(onchange等)
CSS制作政府公文的代码
编写跨浏览器兼容的 CSS 代码
MySQL中文参考手册--输入查询
系统优化:改变Vista脱机文件的缓存位置
Oracle操作中常见的错误和解决方法
asp.net中利用ajax获取动态创建表中文本框的值
ASP.NET程序中用Repeater实现分页
使用ASP实现文件上载(上传)的各种方法
有效管理你的Gentoo USE标记
MYSQL导入数据Got a packet bigger than...错误
用php解析html的实现代码
快速导航

Copyright © 2016 phpStudy |