sql servse 查询当前库内表索引值
2024-09-09 21:13:00
SELECT TOP 100 PERCENT --a.id,
CASE WHEN b.keyno = 1 THEN c.name ELSE '' END AS 表名,
CASE WHEN b.keyno = 1 THEN a.name ELSE '' END AS 索引名称, d.name AS 列名,
b.keyno AS 索引顺序, CASE indexkey_property(c.id, b.indid, b.keyno, 'isdescending')
WHEN 1 THEN '降序' WHEN 0 THEN '升序' END AS 排序, CASE WHEN p.id IS NULL
THEN '' ELSE '√' END AS 主键, CASE INDEXPROPERTY(c.id, a.name, 'IsClustered')
WHEN 1 THEN '√' WHEN 0 THEN '' END AS 聚集, CASE INDEXPROPERTY(c.id,
a.name, 'IsUnique') WHEN 1 THEN '√' WHEN 0 THEN '' END AS 唯一,
CASE WHEN e.id IS NULL THEN '' ELSE '√' END AS 唯一约束,
a.OrigFillFactor AS 填充因子, c.crdate AS 创建时间, c.refdate AS 更改时间
FROM dbo.sysindexes a INNER JOIN
dbo.sysindexkeys b ON a.id = b.id AND a.indid = b.indid INNER JOIN
dbo.syscolumns d ON b.id = d.id AND b.colid = d.colid INNER JOIN
dbo.sysobjects c ON a.id = c.id AND c.xtype = 'U' LEFT OUTER JOIN
dbo.sysobjects e ON e.name = a.name AND e.xtype = 'UQ' LEFT OUTER JOIN
dbo.sysobjects p ON p.name = a.name AND p.xtype = 'PK'
WHERE (OBJECTPROPERTY(a.id, N'IsUserTable') = 1) AND (OBJECTPROPERTY(a.id,
N'IsMSShipped') = 0) AND (INDEXPROPERTY(a.id, a.name, 'IsAutoStatistics') = 0)
ORDER BY c.name, a.name, b.keyno
最新文章
- 基于DDD的.NET开发框架 - ABP依赖注入
- Solr Zookeeper ACL权限配置
- 【LeetCode】264. Ugly Number II
- js刷新当前页面
- Linux Kernel ‘kvm_set_memory_region()’函数本地提权漏洞
- Android 仿QQ微信开场导航以及登陆界面
- [Javascript] Refactoring: Polymorphic Functions
- (转载)XML Tutorial for iOS: How To Choose The Best XML Parser for Your iPhone Project
- 163k地方门户网站系统自动审核信息脚本
- poj 1118 Lining Up(水题)
- layui之事件监听(table)
- IOS开发初体验
- USCiLab cereal json 序列化
- Scala(四) —— 集合
- jquey学习2之jquery动态添加页面片段
- OCP 12c 062题库大更新,出现大量新题-5
- 计算细胞数【BFS】
- LayaBox进阶之UI管理器
- 4.2 使用STM32控制MC20发送短信
- python——matplotlib图像的基本处理