DatabaseTableApplicationCreatedLinks
mastersyslocks  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syslocks(-- 0 Rows, Data: 0 B, Index: 0 B
2         id int not null,
3         dbid smallint not null,
4         page int not null,
5         type smallint not null,
6         spid smallint not null,
7         class varchar(30) null,
8         fid smallint null,
9         context tinyint null,
10        row smallint null,
11        loid int null,
12        partitionid int null,
13        nodeid tinyint null
14    )
15    
16    Grant Select on syslocks to public
17    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[context]master..spt_values[number]20 Simple Join
[type]master..spt_values[number]20 Simple Join

ALIASES USED for master..syslocks
NO_ALIASllo
5101

SCHEMA

COLUMN USAGE
idsp_chgattribute  sp_familylock  sp_lock  sp_monitor_procstack 
dbidsp_chgattribute  sp_familylock  sp_lock  sp_monitor_procstack 
pagesp_familylock  sp_lock  sp_monitor_procstack 
typesp_chgattribute  sp_familylock  sp_lock  sp_monitor_procstack 
spidsp_chgattribute  sp_familylock  sp_lock  sp_monitor_procstack 
classsp_familylock  sp_lock  sp_monitor_procstack 
fidsp_familylock  sp_lock  sp_monitor_procstack 
contextsp_familylock  sp_lock  sp_monitor_procstack 
rowsp_lock  sp_monitor_procstack 
loidsp_familylock  sp_lock  sp_monitor_procstack 
partitionidsp_monitor_procstack 
nodeidsp_monitor_procstack 

QUERIES
Joined With Links
master..spt_values master..spt_values sybsystemprocs..sp_lock:132
sybsystemprocs..sp_lock:69
sybsystemprocs..sp_lock:155
sybsystemprocs..sp_lock:110
sybsystemprocs..sp_lock:95
sybsystemprocs..sp_lock:52

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_procstack  
read by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_familylock  
read by proc sybsystemprocs..sp_lock