DatabaseTableApplicationCreatedLinks
sybsystemprocssysprocedures  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysprocedures(-- 96 KRows, Data: 95 MB, Index: 99 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    
12    create unique clustered index csysprocedures on sysprocedures(-- 3.4 MB refcount: 63
13        id, number, type, sequence
14    )
15    
16    alter table sysprocedures lock datarows
17    
18    Grant Select on sysprocedures to public
19    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]18 FK
[id]sybsystemprocs..syscolumns[cdefault]1 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_jdbc_getfunctioncolumns:94
sybsystemprocs..sp_jdbc_getfunctioncolumns:289
sybsystemprocs..sp_odbc_stored_procedures:90
sybsystemprocs..sp_jdbc_stored_procedures:105
sybsystemprocs..sp_ijdbc_stored_procedures:89
sybsystemprocs..sp_oledb_stored_procedures:93
sybsystemprocs..sp_jdbc_getfunctioncolumns:189
sybsystemprocs..sp_jdbc_getfunctioncolumns:189
sybsystemprocs..sp_stored_procedures:110
sybsystemprocs..sp_oledb_getprocedurecolumns:532
sybsystemprocs..sp_jdbc_getfunctioncolumns:289
sybsystemprocs..sp_jdbc_stored_procedures:213
sybsystemprocs..sp_sproc_columns:537
sybsystemprocs..sp_jdbc_stored_procedures:321
sybsystemprocs..sp_odbc_getprocedurecolumns:576
sybsystemprocs..sp_jdbc_getfunctioncolumns:215
sybsystemprocs..sp_jdbc_getfunctioncolumns:94
sybsystemprocs..sp_jdbc_getfunctioncolumns:215
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..spt_jdatatype_info sybsystemprocs..sp_ijdbc_getprocedurecolumns:92
sybsystemprocs..syscomments sybsystemprocs..sysobjects sybsystemprocs..sp_merge_dup_inline_default:454
sybsystemprocs..sp_merge_dup_inline_default:142
sybsystemprocs..sp_merge_dup_inline_default:142
sybsystemprocs..syscolumns sybsystemprocs..sp_depends_cols:383
sybsystemprocs..sysobjects sybsystemprocs..spt_jdatatype_info sybsystemprocs..systypes sybsystemprocs..sp_ijdbc_getprocedurecolumns:139

COLUMN WRITES detailed
ColumnWritten From
status  sysprocedures.status   sp_merge_dup_inline_default.@?  

DATA PROPAGATION detailed
ColumnWritten To
numbersp_jdbc_stored_procedures_rset_001.PROCEDURE_NAME °.SPECIFIC_NAME sp_jdbc_stored_procedures_rset_002.num_result_sets sp_jdbc_stored_procedures_rset_003.FUNCTION_NAME sp_oledb_stored_procedures_rset_001.PROCEDURE_NAME sp_stored_procedures_rset_001.procedure_name
statussysprocedures.status  

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_unbindrule  
read by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
read by proc sybsystemprocs..sp_bindefault  
read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_odbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_jdbc_stored_procedures  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_unbindefault  
read by proc sybsystemprocs..sp_bindrule  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_sproc_columns  
read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures