| 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 |