SQL SERVER 2005 - RECUPERER LA LISTE DES INDEXES EXISTANT SUR LA BASE COURANTE

-------------------------------------------------------------------------------------
-- LISTE DES INDEXES EXISTANT SUR LA BASE COURANTE
-------------------------------------------------------------------------------------
SELECT 
	IDX.name				AS INDEX_NAME,
	SCH.name				AS SCHEMA_NAME,
	OBJ.name				AS OBJECT_NAME,
	COL.name				AS COLUMN_NAME,
	OBJ.type				AS OBJECT_TYPE,
	IDX.type_desc		AS INDEX_TYPE
FROM  sys.index_columns IDXC
INNER JOIN sys.objects OBJ 
		ON IDXC.object_id = OBJ.object_id 
INNER JOIN sys.schemas SCH
		ON SCH.schema_id = OBJ.schema_id
INNER JOIN sys.indexes IDX 
		ON (IDXC.object_id = IDX.object_id AND IDXC.index_id = IDX.index_id)
INNER JOIN sys.columns COL 
		ON (IDXC.column_id = COL.column_id AND OBJ.object_id = COL.object_id)
WHERE 
	(OBJ.type = 'U' OR OBJ.type = 'V')
-------------------------------------------------------------------------------------