如何查看某种表的索引
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/07/05 00:30:43
如何查看某种表的索引
![如何查看某种表的索引](/uploads/image/z/19350076-4-6.jpg?t=%E5%A6%82%E4%BD%95%E6%9F%A5%E7%9C%8B%E6%9F%90%E7%A7%8D%E8%A1%A8%E7%9A%84%E7%B4%A2%E5%BC%95)
SQL code
USE test
GO
-- 查看某个表的索引
SELECT * FROM sys.sysindexes
WHERE id=object_id('RelactionGraph')
-- 查看整个库的索引
SELECT * FROM sys.sysindexes
-- 查看所有库的索引
IF object_id('tempdb..#')IS NOT NULL
DROP TABLE #
SELECT * INTO # FROM sys.sysindexes WHERE 1=2
INSERT INTO #
EXEC sys.sp_MSforeachdb @command1='Select * from ?.sys.sysindexes'
SELECT * FROM #
USE test
GO
-- 查看某个表的索引
SELECT * FROM sys.sysindexes
WHERE id=object_id('RelactionGraph')
-- 查看整个库的索引
SELECT * FROM sys.sysindexes
-- 查看所有库的索引
IF object_id('tempdb..#')IS NOT NULL
DROP TABLE #
SELECT * INTO # FROM sys.sysindexes WHERE 1=2
INSERT INTO #
EXEC sys.sp_MSforeachdb @command1='Select * from ?.sys.sysindexes'
SELECT * FROM #