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

1     create table sysdepends(-- 1.4 KRows, Data: 50 KB, Index: 98 KB
2         id int not null,
3         number smallint not null,
4         depid int not null,
5         depnumber smallint not null,
6         status smallint not null,
7         selall bit not null,
8         resultobj bit not null,
9         readobj bit not null,
10        columns varbinary(129) null
11    )
12    
13    
14    create unique clustered index csysdepends on sysdepends(-- 48 KB refcount: 15
15        id, number, depid, depnumber
16    ) with ignore_dup_key
17    
18    alter table sysdepends lock datarows
19    
20    Grant Select on sysdepends to public
21    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[depid]sybsystemprocs..sysxtypes[xtid]5 FK
[id]sybsystemprocs..sysobjects[id]3 FK
[depid]sybsystemprocs..sysobjects[id]1 FK
[readobj]master..spt_values[number]1 Simple Join
[resultobj]master..spt_values[number]1 Simple Join

Estimated Index Usage
sysdepends.csysdepends unique clustered(id, number, depid, depnumber)15

ALIASES USED for sybsystemprocs..sysdepends
NO_ALIASd
27

SCHEMA

COLUMN USAGE
idsp_depends  sp_helpjava 
depidsp_depends  sp_helpjava 
resultobjsp_depends 
readobjsp_depends 
columnssp_depends 

QUERIES
Joined With Links
sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_depends:238
master..sysmessages master..sysmessages master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_depends:192
master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:205
sybsystemprocs..sp_helpjava:272
sybsystemprocs..syscolumns sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:194
sybsystemprocs..sysxtypes sybsystemprocs..sp_depends:179
sybsystemprocs..sp_depends:173

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_helpjava