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