用户名:
密 码: 记住
您当前的位置:首页 > 网络编程 > sqlserver教程

使用SQL语句快速获取SQL Server数据字典

时间:2014-11-30  来源:互联网  作者:佚名

本文主要介绍了一个获取SQL(SQL Server培训 mySQL培训 ) 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')

来顶一下
返回首页
返回首页
推荐资讯
从零开始学ASP.NET-基础篇第1/7页 从零开始学ASP.NET-基础篇第1/7页第一天 学习目的: 掌握最基本的Label、TextBox、Button控件
ASP.NET入门数据篇 ASP.NET入门数据篇对于网站编程的初学者来说,总是会上网找些源码来看,但久而
相关文章
栏目更新
栏目热门