1     create table #TmpIndex(-- 0 Rows, Data: 0 B, Index: 0 B
2         table_qualifier varchar(32) not null,
3         table_owner varchar(32) not null,
4         table_name varchar(257) not null,
5         index_qualifier varchar(257) null,
6         index_name varchar(257) null,
7         non_unique varchar(5) not null,
8         type smallint not null,
9         seq_in_index smallint null,
10        column_name varchar(257) null,
11        collation char(1) null,
12        index_id int null,
13        cardinality int null,
14        pages int null,
15        filter_condition varchar(32) null,
16        status smallint not null,
17        table_id int not null
18    )
19    

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_ijdbc_getindexinfo