获取MS SQL库数据字典的经典SQL语句
来源:互联网 发布:mfc 多串口编程 编辑:程序博客网 时间:2024/05/01 10:49
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')
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')
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典
- 获取MSSQL数据字典的SQL语句
- 获取SQLServer的最完整数据字典的SQL语句
- 获取SQLServer的最完整数据字典的SQL语句
- 获取SQLServer 的最完整数据字典的SQL 语句
- 超强的数据导入SQL语句[MS SQL 2005]
- 生成数据字典的sql语句
- sqlserver导出 数据字典的SQL语句
- MS SQL的一些经典常用操作语句汇总
- MS SQL新旧库数据字典比较脚本
- 数据字典(SQL语句)
- SQL生成数据字典语句
- MS SQL获取本周、本月、本季度的记录的语句
- SQL语句生成SQL Server数据库的数据字典
- DIV背景半透明,DIV中的字不半透明
- The pain in my heart
- C#中的值类型及装箱
- 论芙蓉精神于网站发展
- 全面掌握SOA 认清SOA面临的挑战
- 获取MS SQL库数据字典的经典SQL语句
- 毕业有感
- (转帖)小菜编程成长记(八 用“策略模式”是一种好策略)
- C++中union的应用剖析
- C# Infralution Licensing System学习笔记(四)Compact Framework Application应用
- 调试
- 怎样在MDI程序里面切换不同的 视图?
- 初恋有感
- NaviLibrary 研究手记(1)--Navi 介绍