Database | Table | Application | Created | Links |
sybsystemprocs | sysxtypes | 31 Aug 14 | Joins 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 | ||||||||||||||||||||||||
|
Estimated Index Usage | |
sysxtypes.ncsysxtypes unique(xtname) | 9 |
sysxtypes.csysxtypes unique clustered(xtid) | 8 |
ALIASES USED for sybsystemprocs..sysxtypes | ||
NO_ALIAS | sjc | x |
2 | 4 | 25 |
SCHEMA |
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 |