DatabaseTableApplicationCreatedLinks
sybsystemprocssysjars  31 Aug 14Joins Schema ColumnUsage Queries 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     create unique clustered index csysjars on sysjars(-- 2 KB refcount: 6
9         jid
10    )
11    create unique index ncsysjars on sysjars(-- 2 KB refcount: 9
12        jname
13    )
14    
15    alter table sysjars lock datarows
16    
17    Grant Select on sysjars to public
18    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[jid]sybsystemprocs..sysxtypes[xtcontainer]12 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_jdbc_jar_for_class:6
sybsystemprocs..sp_ijdbc_jar_for_class:13
sybsystemprocs..sp_helpjava:184
sybsystemprocs..sp_helpjava:152
sybsystemprocs..sp_jdbc_classes_in_jar:6
sybsystemprocs..sp_ijdbc_classes_in_jar:13

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