Database | Table | Application | Created | Links |
sybsystemprocs | sysprocedures ![]() | ![]() | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysprocedures(-- 88 KRows, Data: 88 MB, Index: 91 MB 2 type smallint not null, 3 id int not null, 4 sequence int not null, 5 status smallint not null, 6 number smallint not null, 7 version int null, 8 qp_setting varbinary(6) null 9 ) 10 11 create unique clustered index csysprocedures on sysprocedures(-- 3.1 MB refcount: 63 12 id, number, type, sequence 13 ) 14 15 alter table sysprocedures lock datarows 16 17 Grant Select on sysprocedures to public 18
JOINS | ||||||||||||||||||
|
Estimated Index Usage | |
sysprocedures.csysprocedures unique clustered(id, number, type, sequence) | 63 |
ALIASES USED for sybsystemprocs..sysprocedures | ||||
NO_ALIAS | P | p | pr | sysprocedures |
6 | 2 | 18 | 1 | 2 |
SCHEMA |
![]() |
DEPENDENCIES |
READERS AND WRITERS read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns ![]() read by proc sybsystemprocs..sp_ijdbc_stored_procedures ![]() read by proc sybsystemprocs..sp_oledb_getprocedurecolumns ![]() read by proc sybsystemprocs..sp_sproc_columns ![]() read by proc sybsystemprocs..sp_bindrule ![]() read by proc sybsystemprocs..sp_oledb_stored_procedures ![]() read by proc sybsystemprocs..sp_odbc_getprocedurecolumns ![]() read by proc sybsystemprocs..sp_depends ![]() read_written by proc sybsystemprocs..sp_merge_dup_inline_default ![]() read by proc sybsystemprocs..sp_jdbc_stored_procedures ![]() read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns ![]() read by proc sybsystemprocs..sp_odbc_stored_procedures ![]() read by proc sybsystemprocs..sp_unbindrule ![]() read by proc sybsystemprocs..sp_unbindefault ![]() read by proc sybsystemprocs..sp_bindefault ![]() read by proc sybsystemprocs..sp_stored_procedures ![]() read by proc sybsystemprocs..sp_depends_cols ![]() called by proc sybsystemprocs..sp_depends ![]() |