DatabaseTableApplicationCreatedLinks
sybsystemprocssyssegments  31 Aug 14Joins Schema ColumnUsage Queries 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     alter table syssegments lock datarows
8     
9     Grant Select on syssegments to public
10    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[segment]sybsystemprocs..syspartitions[segment]16 Simple Join
[segment]sybsystemprocs..systhresholds[segment]16 Simple Join
[segment]sybsystemprocs..sysindexes[segment]6 Simple Join
[name]master..spt_values[name]4 Simple Join

ALIASES USED for sybsystemprocs..syssegments
NO_ALIASgssyssegments
252191

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:289
sybsystemprocs..sp_checkreswords:285
sybsystemprocs..sysindexes sybsystemprocs..sp_helpsegment:215
sybsystemprocs..sp_helpsegment:205
sybsystemprocs..sysindexes sybsystemprocs..syspartitions sybsystemprocs..sp_dropsegment:259
sybsystemprocs..sp_helpsegment:193
sybsystemprocs..syspartitions sybsystemprocs..sp_helpindex:329
sybsystemprocs..sp_objectsegment:70
sybsystemprocs..sp_helpartition:566
sybsystemprocs..sp_helpartition:579
sybsystemprocs..sp_helpartition:490
sybsystemprocs..sp_helpsegment:183
sybsystemprocs..systhresholds sybsystemprocs..sp_helpthreshold:74
sybsystemprocs..sp_dropsegment:351
sybsystemprocs..sp_dropalias:181
sybsystemprocs..sp_helpthreshold:102
sybsystemprocs..sp_helpthreshold:59
sybsystemprocs..sp_dropsegment:409
sybsystemprocs..sp_helpthreshold:91
sybsystemprocs..sp_dropuser:357

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