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 #
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024