INDEXの一覧

col tbl for a20
col ind for a20
col "No." for 999
bre on tbl ski page on ind ski 1

select i1.table_name as tbl, i1.index_name as ind, i1.uniqueness as "U?",
       i2.column_position as "No.", i2.column_name, c1.comments
  from user_indexes i1
  join user_ind_columns i2
    on i1.index_name = i2.index_name and i1.table_name= i2.table_name
  left join user_col_comments c1
    on i2.table_name = c1.table_name and i2.column_name = c1.column_name
 where i1.table_name in ('テーブル名称')
 order by i1.table_name, i1.uniqueness desc, i1.index_name, i2.column_position