DatabaseTableApplicationCreatedLinks
sybsystemprocssysdepends  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysdepends(-- 1.2 KRows, Data: 46 KB, Index: 90 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    create unique clustered index csysdepends on sysdepends(-- 44 KB refcount: 15
14        id, number, depid, depnumber
15    ) with ignore_dup_key
16    
17    alter table sysdepends lock datarows
18    
19    Grant Select on sysdepends to public
20    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[depid]sybsystemprocs..sysxtypes[xtid]10 FK
[id]sybsystemprocs..sysobjects[id]6 FK
[depid]sybsystemprocs..sysobjects[id]2 FK
[readobj]master..spt_values[number]2 Simple Join
[resultobj]master..spt_values[number]2 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:213
master..sysmessages master..sysmessages master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_depends:171
master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:272
sybsystemprocs..sp_helpjava:205
sybsystemprocs..syscolumns sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:194
sybsystemprocs..sysxtypes sybsystemprocs..sp_depends:152
sybsystemprocs..sp_depends:158

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