DatabaseTableApplicationCreatedLinks
sybsystemprocssysjars  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysjars(-- 0 Rows, Data: 2 KB, Index: 6 KB
2         jstatus smallint not null,
3         jid int not null,
4         jname varchar(255) null,
5         jbinary image null
6     )
7     
8     
9     create unique clustered index csysjars on sysjars(-- 2 KB refcount: 6
10        jid
11    )
12    create unique index ncsysjars on sysjars(-- 2 KB refcount: 9
13        jname
14    )
15    
16    alter table sysjars lock datarows
17    
18    Grant Select on sysjars to public
19    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[jid]sybsystemprocs..sysxtypes[xtcontainer]6 Rev FK

Estimated Index Usage
sysjars.ncsysjars unique(jname)9
sysjars.csysjars unique clustered(jid)6

ALIASES USED for sybsystemprocs..sysjars
NO_ALIASjsj
166

SCHEMA

COLUMN USAGE
jidsp_help  sp_helpjava  sp_ijdbc_classes_in_jar  sp_ijdbc_jar_for_class  sp_jdbc_classes_in_jar  sp_jdbc_jar_for_class 
jnamesp_help  sp_helpjava  sp_ijdbc_classes_in_jar  sp_ijdbc_jar_by_name  sp_jdbc_classes_in_jar  sp_jdbc_jar_by_name 
jbinarysp_ijdbc_jar_by_name  sp_ijdbc_jar_for_class  sp_jdbc_jar_by_name  sp_jdbc_jar_for_class 

QUERIES
Joined With Links
sybsystemprocs..sysxtypes sybsystemprocs..sp_ijdbc_jar_for_class:13
sybsystemprocs..sp_jdbc_classes_in_jar:5
sybsystemprocs..sp_jdbc_jar_for_class:5
sybsystemprocs..sp_helpjava:152
sybsystemprocs..sp_ijdbc_classes_in_jar:13
sybsystemprocs..sp_helpjava:184

DATA PROPAGATION detailed
ColumnWritten To
jbinarysp_jdbc_jar_by_name_rset_001.jbinary sp_jdbc_jar_for_class_rset_001.jbinary

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_ijdbc_jar_by_name  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_jdbc_classes_in_jar  
read by proc sybsystemprocs..sp_jdbc_jar_by_name  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_jdbc_jar_for_class  
read by proc sybsystemprocs..sp_ijdbc_classes_in_jar  
read by proc sybsystemprocs..sp_ijdbc_jar_for_class