Guarda el contenido de lo que te envia el sp_helpindex
Código SQL:
Ver originalDROP TABLE #tables
DROP TABLE #indices
DECLARE @tabla sysname
DECLARE @record INT
CREATE TABLE #tables (id INT IDENTITY PRIMARY KEY, name sysname)
CREATE TABLE #indices (tabla VARCHAR(50), index_name sysname, index_description VARCHAR(50), index_keys VARCHAR(255))
INSERT INTO #tables (name)
SELECT name FROM sysobjects WHERE TYPE='U' ORDER BY name
SET @record = 1
WHILE @record <= (SELECT MAX(id) FROM #tables)
BEGIN
SELECT @tabla = name FROM #tables WHERE id = @record
INSERT INTO #indices (index_name, index_description, index_keys)
EXEC sp_helpindex @tabla
UPDATE #indices SET [tabla] = @tabla
SET @record = @record + 1
END
GO
-- al final solo haces un select a la tabla #indices
SELECT * FROM #indices