sqlserver 获取数据字典的经典脚本
来源:互联网 发布:资金控盘指标源码 编辑:程序博客网 时间:2024/05/23 15:48
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')
- sqlserver 获取数据字典的经典脚本
- sqlserver 的数据字典
- 获取SQLServer的最完整数据字典的SQL语句
- 获取SQLServer的最完整数据字典的SQL语句
- 获取SQLServer 的最完整数据字典的SQL 语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取MS SQL库数据字典的经典SQL语句
- 获取SQL Server 数据字典脚本
- sqlserver导出 数据字典的SQL语句
- 生成数据字典(sqlserver)
- Sqlserver数据字典
- sqlserver 数据字典
- sqlserver 数据字典查询
- 获取数据字典的方法
- sqlserver---获取前一天的数据
- 生成MySQL数据字典的PHP脚本
- PHP内存设置
- 增加字典类型
- 快速替换字符串 c#
- Oracle数据库连接技术参考
- 使用VSTS进行单元测试
- sqlserver 获取数据字典的经典脚本
- 取消wfp,替换系统文件
- 使用SOCKET API写的客户端与服务端测试程序(C语言)
- MTK自带的XML解析
- C#中怎么复制数组?C#复制数组的5种方法!
- 使用word时,想在中间补充一个字符,可是却自动删除了后面一个字符
- 细数80后不为人知的13种寂寞
- GCD_LCM问题
- invalidateRect