DatabaseTableApplicationCreatedLinks
sybsystemprocssysxtypes  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysxtypes(-- 0 Rows, Data: 2 KB, Index: 6 KB
2         xtutid smallint not null,
3         xtid int not null,
4         xtmetatype int not null,
5         xtstatus int not null,
6         xtcontainer int not null,
7         xtname varchar(255) null,
8         xtsource text null,
9         xtbinaryinrow varbinary(255) null,
10        xtbinaryoffrow image null
11    )
12    
13    create unique clustered index csysxtypes on sysxtypes(-- 2 KB refcount: 8
14        xtid
15    )
16    create unique index ncsysxtypes on sysxtypes(-- 2 KB refcount: 9
17        xtname
18    )
19    
20    alter table sysxtypes lock datarows
21    
22    Grant Select on sysxtypes to public
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[xtcontainer]sybsystemprocs..sysjars[jid]12 FK
[xtid]sybsystemprocs..sysdepends[depid]10 Rev FK
[xtid]sybsystemprocs..syscolumns[xtype]6 Rev FK

Estimated Index Usage
sysxtypes.ncsysxtypes unique(xtname)9
sysxtypes.csysxtypes unique clustered(xtid)8

ALIASES USED for sybsystemprocs..sysxtypes
NO_ALIASsjcx
2425

SCHEMA

COLUMN USAGE
xtidsp_depends  sp_help  sp_helpjava  sp_help_params  sp_ijdbc_columns  sp_jdbc_columns  sp_odbc_columns 
xtcontainersp_help  sp_helpjava  sp_ijdbc_classes_in_jar  sp_ijdbc_jar_for_class  sp_jdbc_classes_in_jar  sp_jdbc_jar_for_class 
xtnamesp_depends  sp_help  sp_helpjava  sp_help_params  sp_ijdbc_classes_in_jar  sp_ijdbc_class_for_name  sp_ijdbc_columns  sp_ijdbc_jar_for_class  sp_jdbc_classes_in_jar  sp_jdbc_class_for_name  sp_jdbc_columns  sp_jdbc_jar_for_class  sp_odbc_columns 
xtbinaryoffrowsp_ijdbc_class_for_name  sp_jdbc_class_for_name 

QUERIES
Joined With Links
sybsystemprocs..syscolumns master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_helpjava:289
sybsystemprocs..sp_helpjava:223
sybsystemprocs..sysdepends master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_helpjava:272
sybsystemprocs..sp_helpjava:205
sybsystemprocs..syscolumns sybsystemprocs..sysdepends sybsystemprocs..sp_helpjava:194
sybsystemprocs..sysdepends sybsystemprocs..sp_depends:152
sybsystemprocs..sp_depends:158
sybsystemprocs..sysjars 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_jdbc_classes_in_jar  
read by proc sybsystemprocs..sp_jdbc_columns  
read by proc sybsystemprocs..sp_odbc_columns  
read by proc sybsystemprocs..sp_jdbc_class_for_name  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_help_params  
   called by proc sybsystemprocs..sp_showtext_sproc_tagline  
      called by proc sybsystemprocs..sp_showtext_output  
         called by proc sybsystemprocs..sp_showtext  
            called by proc sybsystemprocs..sp_helptext  
            called by proc sybsystemprocs..sp_helptext_usage  
               called by proc sybsystemprocs..sp_helptext  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_ijdbc_class_for_name  
read by proc sybsystemprocs..sp_ijdbc_jar_for_class  
read by proc sybsystemprocs..sp_ijdbc_columns  
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_ijdbc_classes_in_jar  
read by proc sybsystemprocs..sp_jdbc_jar_for_class  
read by proc sybsystemprocs..sp_help