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

1     create table syssegments(-- 0 Rows, Data: 2 KB, Index: 0 B
2         segment smallint not null,
3         name sysname not null,
4         status smallint null
5     )
6     
7     
8     alter table syssegments lock datarows
9     
10    Grant Select on syssegments to public
11    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[segment]sybsystemprocs..syspartitions[segment]9 Simple Join
[segment]sybsystemprocs..systhresholds[segment]8 Simple Join
[segment]sybsystemprocs..sysindexes[segment]3 Simple Join
[name]master..spt_values[name]2 Simple Join

ALIASES USED for sybsystemprocs..syssegments
NO_ALIASgssyssegments
252201

SCHEMA

COLUMN USAGE
segmentsp_addsegment  sp_addthreshold  sp_checknames  sp_dropalias  sp_dropsegment  sp_dropthreshold  sp_dropuser  sp_extendsegment  sp_helpartition  sp_helpdb  sp_helpindex  sp_helpsegment  sp_helpthreshold  sp_modifythreshold  sp_objectsegment  sp_placeobject 
namesp_addsegment  sp_addthreshold  sp_checknames  sp_checkreswords  sp_dropalias  sp_dropsegment  sp_dropthreshold  sp_dropuser  sp_extendsegment  sp_helpartition  sp_helpdb  sp_helpindex  sp_helpsegment  sp_helpthreshold  sp_modifythreshold  sp_objectsegment  sp_placeobject 
statussp_addsegment  sp_extendsegment  sp_helpsegment  sp_placeobject 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:292
sybsystemprocs..sp_checkreswords:288
sybsystemprocs..sysindexes sybsystemprocs..sp_helpsegment:217
sybsystemprocs..sp_helpsegment:228
sybsystemprocs..sysindexes sybsystemprocs..syspartitions sybsystemprocs..sp_dropsegment:289
sybsystemprocs..sp_helpsegment:179
sybsystemprocs..sp_helpsegment:204
sybsystemprocs..syspartitions sybsystemprocs..sp_helpartition:587
sybsystemprocs..sp_helpartition:574
sybsystemprocs..sp_helpsegment:193
sybsystemprocs..sp_objectsegment:70
sybsystemprocs..sp_helpartition:490
sybsystemprocs..sp_helpindex:376
sybsystemprocs..systhresholds 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  sp_addsegment.@?  
name  sp_addsegment.@segname  
status  sp_addsegment.@?  

DATA PROPAGATION detailed
ColumnWritten To
namesp_checkreswords_rset_009.Reserved Word User Names sp_dropalias_rset_001.name sp_dropuser_rset_001.name
segmentsysusages.segmap   sysindexes.segment   syspartitions.segment   systhresholds.segment   sp_checknames_rset_002.name

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_helpdb  
read by proc sybsystemprocs..sp_placeobject  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_helpthreshold  
read_written by proc sybsystemprocs..sp_addsegment  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_modifythreshold  
read by proc sybsystemprocs..sp_helpsegment  
read by proc sybsystemprocs..sp_extendsegment  
read by proc sybsystemprocs..sp_addthreshold  
read by proc sybsystemprocs..sp_dropalias  
read by proc sybsystemprocs..sp_objectsegment  
read_written by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_dropthreshold