×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Oracle - Liste des index d'une table

0
0
 
0
Language: SQL
Posted by: karl.buleon
Added: Jun 14, 2019 10:24 AM
Modified: Jun 14, 2019 10:27 AM
Views: 3960
Tags: oracle sql
  1. SELECT
  2.  all_ind_columns.index_name || '    ' ||
  3.  all_indexes.uniqueness
  4.  || '    ' || '---->    ' ||
  5.  all_ind_columns.column_name " Index"
  6. FROM all_indexes, all_ind_columns
  7. WHERE all_indexes.table_name = UPPER('&1')
  8.   AND all_ind_columns.table_name = all_indexes.table_name
  9.   AND all_ind_columns.index_name = all_indexes.index_name
  10. ORDER BY all_ind_columns.index_name,column_position;
Comments disabled