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=2INSERT INTO # EXEC sys.sp_MSforeachdb @command1='Select * from ?.sys.sysindexes'
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=2INSERT INTO #
EXEC sys.sp_MSforeachdb @command1='Select * from ?.sys.sysindexes'
SELECT * FROM #
EXEC sp_helpindex 'person.person'