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

1     create table systhresholds(-- 0 Rows, Data: 2 KB, Index: 0 B
2         segment smallint not null,
3         free_space uint not null,
4         status smallint not null,
5         proc_name varchar(255) not null,
6         suid int null,
7         currauth varbinary(255) null
8     )
9     
10    
11    alter table systhresholds lock datarows
12    
13    Grant Select on systhresholds to public
14    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[segment]sybsystemprocs..syssegments[segment]8 Simple Join

ALIASES USED for sybsystemprocs..systhresholds
NO_ALIASbsysthresholdst
13156

SCHEMA

COLUMN USAGE
segmentsp_addthreshold  sp_dropalias  sp_dropsegment  sp_dropthreshold  sp_dropuser  sp_helpthreshold  sp_modifythreshold 
free_spacesp_addthreshold  sp_dropalias  sp_dropsegment  sp_dropthreshold  sp_dropuser  sp_helpthreshold  sp_modifythreshold 
statussp_addthreshold  sp_dropthreshold  sp_helpthreshold  sp_modifythreshold 
proc_namesp_addthreshold  sp_changedbowner  sp_helpthreshold  sp_modifythreshold 
suidsp_addthreshold  sp_changedbowner  sp_dropalias  sp_dropuser  sp_modifythreshold 
currauthsp_addthreshold  sp_changedbowner  sp_modifythreshold 

QUERIES
Joined With Links
sybsystemprocs..syssegments sybsystemprocs..sp_helpthreshold:91
sybsystemprocs..sp_helpthreshold:74
sybsystemprocs..sp_dropuser:469
sybsystemprocs..sp_helpthreshold:102
sybsystemprocs..sp_dropsegment:379
sybsystemprocs..sp_helpthreshold:59
sybsystemprocs..sp_dropalias:224
sybsystemprocs..sp_dropsegment:431

COLUMN WRITES detailed
ColumnWritten From
segment  syssegments.segment   sp_addsegment.@?  
free_space  sp_modifythreshold.@free_space   sp_modifythreshold.@new_free_space   sp_addthreshold.@free_space  
status  systhresholds.status   sp_addthreshold.@?  
proc_name  systhresholds.proc_name   sp_modifythreshold.@?   sp_addthreshold.@proc_name   sp_modifythreshold.@new_proc_name  
suid    syslogins.suid   sp_modifythreshold.@?   sp_gen_login_id.@?   sp_addthreshold.@?  
currauth  sp_modifythreshold.@?   sp_addthreshold.@?  

DATA PROPAGATION detailed
ColumnWritten To
free_spacesp_dropalias_rset_001.type sp_dropthreshold_rset_001.free_space sp_dropuser_rset_001.type sp_modifythreshold_rset_001.free_space sp_modifythreshold_rset_002.free_space
proc_namesysthresholds.proc_name  
statussysthresholds.status  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_dropsegment  
read_written by proc sybsystemprocs..sp_modifythreshold  
read by proc sybsystemprocs..sp_dropalias  
read_written by proc sybsystemprocs..sp_changedbowner  
read_written by proc sybsystemprocs..sp_dropthreshold  
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_helpthreshold  
read_written by proc sybsystemprocs..sp_addthreshold