Lister les indexes

Posted by DiabloCorps on 12 octobre 2010 Leave a comment (0) Go to comments 
SELECT Table_Name, Index_Name, Status FROM All_Indexes;

ou

SELECT * FROM All_Ind_Columns 
WHERE Table_Owner = 'propriétaire' AND Table_Name = 'maTable';
Oracle, ,

Laisser un commentaire