rem --------------------------------------------------
rem インデックス表示SQL
rem Usage: @showind テーブル名
rem --------------------------------------------------
set linesize 100
set pagesize 30
col index_name format A20
col table_name format A20
col index_type format A4
col column_name format A20
select t.table_name, t.index_name, t.index_type, t.status, c.column_name, c.column_position
from sys.all_indexes t, sys.all_ind_columns c
where t.table_name = '&1'
and t.table_owner=c.table_owner
and t.index_name=c.index_name
and t.table_name=c.table_name
order by t.table_name, t.index_name, c.column_position
/
|