DatabaseTableApplicationCreatedLinks
sybsystemprocssp_jdbc_getindexinfo_rset_002   01 janv. 70Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sp_jdbc_getindexinfo_rset_002(-- 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         NON_UNIQUE varchar(5) not null,
6         INDEX_QUALIFIER varchar(32) not null,
7         INDEX_NAME varchar(255) not null,
8         TYPE smallint not null,
9         ORDINAL_POSITION smallint not null,
10        COLUMN_NAME varchar(255) not null,
11        ASC_OR_DESC char(1) not null,
12        CARDINALITY int not null,
13        PAGES int not null,
14        FILTER_CONDITION varchar(32) not null
15    )
16    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
TABLE_CAT  sp_jdbc_getindexinfo.@?  
TABLE_SCHEM  sysobjects.uid   sp_jdbc_getindexinfo.@?  
TABLE_NAME  sysobjects.name   sp_rename.@newname  
NON_UNIQUE  sp_jdbc_getindexinfo.@?  
INDEX_QUALIFIER  sysobjects.name   sp_rename.@newname   sp_jdbc_getindexinfo.@?  
INDEX_NAME  sysindexes.name   sp_rename.@newname   sp_rename.@?   sp_jdbc_getindexinfo.@?  
TYPE  sp_jdbc_getindexinfo.@?  
ORDINAL_POSITION  syscolumns.colid   sp_jdbc_getindexinfo.@?  
COLUMN_NAME  sysobjects.uid   °.name   sysindexes.indid   syscolumns.colid   sp_rename.@newname   sp_jdbc_getindexinfo.@?  
ASC_OR_DESC  sp_jdbc_getindexinfo.@?  
CARDINALITY  sysindexes.id   sp_jdbc_getindexinfo.@?  
PAGES  sysindexes.indid   °.id   sp_jdbc_getindexinfo.@?  
FILTER_CONDITION  sp_jdbc_getindexinfo.@?  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_jdbc_getindexinfo