DatabaseTableApplicationCreatedLinks
sybsystemprocssysprocedures  31 Aug 14Joins 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
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]36 FK
[id]sybsystemprocs..syscolumns[cdefault]2 Simple Join

Estimated Index Usage
sysprocedures.csysprocedures unique clustered(id, number, type, sequence)63

ALIASES USED for sybsystemprocs..sysprocedures
NO_ALIASPpprsysprocedures
621812

SCHEMA

COLUMN USAGE
typesp_depends  sp_merge_dup_inline_default 
idsp_bindefault  sp_bindrule  sp_depends  sp_depends_cols  sp_ijdbc_getprocedurecolumns  sp_ijdbc_stored_procedures  sp_jdbc_getfunctioncolumns  sp_jdbc_stored_procedures  sp_merge_dup_inline_default  sp_odbc_getprocedurecolumns  sp_odbc_stored_procedures  sp_oledb_getprocedurecolumns  sp_oledb_stored_procedures  sp_sproc_columns  sp_stored_procedures  sp_unbindefault  sp_unbindrule 
sequencesp_bindefault  sp_bindrule  sp_depends_cols  sp_ijdbc_stored_procedures  sp_jdbc_stored_procedures  sp_merge_dup_inline_default  sp_odbc_stored_procedures  sp_oledb_stored_procedures  sp_stored_procedures  sp_unbindefault  sp_unbindrule 
statussp_bindefault  sp_bindrule  sp_depends_cols  sp_merge_dup_inline_default  sp_unbindefault  sp_unbindrule 
numbersp_ijdbc_getprocedurecolumns  sp_ijdbc_stored_procedures  sp_jdbc_getfunctioncolumns  sp_jdbc_stored_procedures  sp_merge_dup_inline_default  sp_oledb_stored_procedures  sp_sproc_columns  sp_stored_procedures 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_odbc_stored_procedures:88
sybsystemprocs..sp_jdbc_getfunctioncolumns:94
sybsystemprocs..sp_jdbc_getfunctioncolumns:215
sybsystemprocs..sp_jdbc_getfunctioncolumns:289
sybsystemprocs..sp_jdbc_getfunctioncolumns:215
sybsystemprocs..sp_jdbc_getfunctioncolumns:189
sybsystemprocs..sp_jdbc_getfunctioncolumns:94
sybsystemprocs..sp_jdbc_getfunctioncolumns:289
sybsystemprocs..sp_jdbc_stored_procedures:107
sybsystemprocs..sp_oledb_stored_procedures:93
sybsystemprocs..sp_ijdbc_stored_procedures:89
sybsystemprocs..sp_jdbc_stored_procedures:323
sybsystemprocs..sp_sproc_columns:537
sybsystemprocs..sp_jdbc_getfunctioncolumns:189
sybsystemprocs..sp_oledb_getprocedurecolumns:530
sybsystemprocs..sp_odbc_getprocedurecolumns:574
sybsystemprocs..sp_jdbc_stored_procedures:215
sybsystemprocs..sp_stored_procedures:94
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..spt_jdatatype_info sybsystemprocs..sp_ijdbc_getprocedurecolumns:92
sybsystemprocs..syscomments sybsystemprocs..sysobjects sybsystemprocs..sp_merge_dup_inline_default:120
sybsystemprocs..sp_merge_dup_inline_default:120
sybsystemprocs..sp_merge_dup_inline_default:432
sybsystemprocs..syscolumns sybsystemprocs..sp_depends_cols:383
sybsystemprocs..sysobjects sybsystemprocs..spt_jdatatype_info sybsystemprocs..systypes sybsystemprocs..sp_ijdbc_getprocedurecolumns:139

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