1     create table #TmpIndex(-- 0 Rows, Data: 0 B, Index: 0 B
2         TABLE_CAT varchar(32) not null,
3         TABLE_SCHEM varchar(32) not null,
4         TABLE_NAME varchar(255) not null,
5         INDEX_QUALIFIER varchar(32) null,
6         INDEX_NAME varchar(255) null,
7         NON_UNIQUE varchar(5) not null,
8         TYPE smallint not null,
9         ORDINAL_POSITION smallint null,
10        COLUMN_NAME varchar(255) null,
11        ASC_OR_DESC 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_jdbc_getindexinfo