DatabaseTableApplicationCreatedLinks
tempdb#TmpIndex_crby_sybsystemprocs__sp_odbc_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(255) null,
6         INDEX_NAME varchar(255) null,
7         NON_UNIQUE smallint 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        status2 smallint not null
18    )
19    
COLUMN USAGE
TABLE_CATsp_odbc_getindexinfo 
TABLE_SCHEMsp_odbc_getindexinfo 
TABLE_NAMEsp_odbc_getindexinfo 
INDEX_QUALIFIERsp_odbc_getindexinfo 
INDEX_NAMEsp_odbc_getindexinfo 
NON_UNIQUEsp_odbc_getindexinfo 
TYPEsp_odbc_getindexinfo 
ORDINAL_POSITIONsp_odbc_getindexinfo 
COLUMN_NAMEsp_odbc_getindexinfo 
ASC_OR_DESCsp_odbc_getindexinfo 
index_idsp_odbc_getindexinfo 
CARDINALITYsp_odbc_getindexinfo 
PAGESsp_odbc_getindexinfo 
FILTER_CONDITIONsp_odbc_getindexinfo 
statussp_odbc_getindexinfo 
status2sp_odbc_getindexinfo 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_odbc_getindexinfo