DatabaseTableApplicationCreatedLinks
tempdb#TmpIndex_crby_sybsystemprocs__sp_jdbc_getindexinfo  01 Jan 70Joins Schema ColumnUsage Queries Dependencies

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    
COLUMN USAGE
TABLE_CATsp_jdbc_getindexinfo 
TABLE_SCHEMsp_jdbc_getindexinfo 
TABLE_NAMEsp_jdbc_getindexinfo 
INDEX_QUALIFIERsp_jdbc_getindexinfo 
INDEX_NAMEsp_jdbc_getindexinfo 
NON_UNIQUEsp_jdbc_getindexinfo 
TYPEsp_jdbc_getindexinfo 
ORDINAL_POSITIONsp_jdbc_getindexinfo 
COLUMN_NAMEsp_jdbc_getindexinfo 
ASC_OR_DESCsp_jdbc_getindexinfo 
index_idsp_jdbc_getindexinfo 
CARDINALITYsp_jdbc_getindexinfo 
PAGESsp_jdbc_getindexinfo 
FILTER_CONDITIONsp_jdbc_getindexinfo 
statussp_jdbc_getindexinfo 
table_idsp_jdbc_getindexinfo 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_jdbc_getindexinfo