DatabaseTableApplicationCreatedLinks
sybsystemprocssysxtypes  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation 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    
14    create unique clustered index csysxtypes on sysxtypes(-- 2 KB refcount: 8
15        xtid
16    )
17    create unique index ncsysxtypes on sysxtypes(-- 2 KB refcount: 9
18        xtname
19    )
20    
21    alter table sysxtypes lock datarows
22    
23    Grant Select on sysxtypes to public
24    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[xtcontainer]sybsystemprocs..sysjars[jid]6 FK
[xtid]sybsystemprocs..sysdepends[depid]5 Rev FK
[xtid]sybsystemprocs..syscolumns[xtype]3 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_help_params  sp_helpjava  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_help_params  sp_helpjava  sp_ijdbc_class_for_name  sp_ijdbc_classes_in_jar  sp_ijdbc_columns  sp_ijdbc_jar_for_class  sp_jdbc_class_for_name  sp_jdbc_classes_in_jar  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:223
sybsystemprocs..sp_helpjava:289
sybsystemprocs..sysdepends master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_helpjava:205
sybsystemprocs..sp_helpjava:272
sybsystemprocs..syscolumns sybsystemprocs..sysdepends sybsystemprocs..sp_helpjava:194
sybsystemprocs..sysdepends sybsystemprocs..sp_depends:179
sybsystemprocs..sp_depends:173
sybsystemprocs..sysjars 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
xtbinaryoffrowsp_jdbc_class_for_name_rset_001.xtbinaryoffrow
xtnamesp_jdbc_classes_in_jar_rset_001.xtname

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_jdbc_jar_for_class  
read by proc sybsystemprocs..sp_ijdbc_class_for_name  
read by proc sybsystemprocs..sp_ijdbc_columns  
read by proc sybsystemprocs..sp_ijdbc_jar_for_class  
read by proc sybsystemprocs..sp_jdbc_classes_in_jar  
read by proc sybsystemprocs..sp_ijdbc_classes_in_jar  
read by proc sybsystemprocs..sp_jdbc_class_for_name  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_depends  
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_jdbc_columns  
read by proc sybsystemprocs..sp_odbc_columns