DatabaseTableApplicationCreatedLinks
mastersysservers  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysservers(-- 4 Rows, Data: 2 KB, Index: 6 KB
2         srvid smallint not null,
3         srvstatus smallint not null,
4         srvname varchar(30) not null,
5         srvnetname varchar(255) not null,
6         srvclass smallint null,
7         srvsecmech varchar(30) null,
8         srvcost smallint null,
9         srvstatus2 uint null,
10        srvprincipal varchar(255) null
11    )
12    
13    create unique clustered index csysservers on sysservers(-- 2 KB refcount: 56
14        srvid
15    )
16    create unique index ncsysservers on sysservers(-- 2 KB refcount: 52
17        srvname
18    )
19    
20    alter table sysservers lock datarows
21    
22    Grant Select on sysservers to public
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[srvid]master..sysremotelogins[remoteserverid]28 Rev FK
[srvid]master..sysattributes[object_info1]10 Rev FK
[srvnetname]master..spt_values[name]4 Simple Join
[srvname]master..spt_values[name]4 Rev FK
[srvid]sybsystemdb..syscoordinations[participant]2 Rev FK

Estimated Index Usage
sysservers.csysservers unique clustered(srvid)56
sysservers.ncsysservers unique(srvname)52

ALIASES USED for master..sysservers
NO_ALIASssysservers
444014

SCHEMA

COLUMN USAGE
srvidsp_addexternlogin  sp_addobjectdef  sp_addremotelogin  sp_addserver  sp_checknames  sp_dropexternlogin  sp_dropremotelogin  sp_dropserver  sp_helpexternlogin  sp_helpremotelogin  sp_helpserver  sp_remoteoption  sp_serveroption 
srvstatussp_addserver  sp_helpserver  sp_serveroption 
srvnamesp_addexternlogin  sp_addobjectdef  sp_addremotelogin  sp_addserver  sp_autoconnect  sp_checknames  sp_checkreswords  sp_defaultloc  sp_downgrade  sp_dropexternlogin  sp_dropremotelogin  sp_dropserver  sp_dumpoptimize  sp_extengine  sp_helpexternlogin  sp_helpremotelogin  sp_helpserver  sp_remoteoption  sp_serveroption  sp_volchanged 
srvnetnamesp_addserver  sp_checknames  sp_checkreswords  sp_downgrade  sp_dropserver  sp_dumpoptimize  sp_extengine  sp_helpserver  sp_serveroption  sp_volchanged 
srvclasssp_addexternlogin  sp_addobjectdef  sp_addserver  sp_dropexternlogin  sp_dropserver  sp_extengine  sp_helpserver  sp_serveroption 
srvsecmechsp_helpserver  sp_serveroption 
srvcostsp_addserver  sp_helpserver  sp_serveroption 
srvstatus2sp_addserver  sp_dropserver  sp_dumpoptimize  sp_helpserver  sp_serveroption 
srvprincipalsp_helpserver  sp_serveroption 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:379
sybsystemprocs..sp_checkreswords:383
sybsystemprocs..sp_checkreswords:391
sybsystemprocs..sp_checkreswords:395
master..sysremotelogins master..spt_values sybsystemprocs..sp_helpremotelogin:142
master..sysmessages master..sysremotelogins master..spt_values sybsystemprocs..sp_helpremotelogin:161
master..sysattributes sybsystemprocs..sp_dropserver:271
sybsystemprocs..sp_dropserver:315
sybsystemprocs..sp_helpexternlogin:131
master..sysattributes master..syslogins sybsystemprocs..sp_helpexternlogin:117
master..sysattributes master..syssrvroles sybsystemprocs..sp_helpexternlogin:160
master..sysremotelogins sybsystemprocs..sp_addremotelogin:352
sybsystemprocs..sp_addremotelogin:210
sybsystemprocs..sp_addremotelogin:281
sybsystemprocs..sp_dropserver:255
sybsystemprocs..sp_remoteoption:175
sybsystemprocs..sp_remoteoption:360
sybsystemprocs..sp_addremotelogin:306
sybsystemprocs..sp_helpremotelogin:46
sybsystemprocs..sp_dropremotelogin:163
sybsystemprocs..sp_helpremotelogin:100
sybsystemprocs..sp_dropserver:294
sybsystemprocs..sp_remoteoption:335
sybsystemdb..syscoordinations sybsystemprocs..sp_dropserver:238

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_downgrade  
read_written by proc sybsystemprocs..sp_addserver  
read by proc sybsystemprocs..sp_extengine  
read by proc sybsystemprocs..sp_volchanged  
read by proc sybsystemprocs..sp_dumpoptimize  
read_written by proc sybsystemprocs..sp_serveroption  
read by proc sybsystemprocs..sp_helpserver  
read by proc sybsystemprocs..sp_dropexternlogin  
read by proc sybsystemprocs..sp_addremotelogin  
read by proc sybsystemprocs..sp_remoteoption  
read by proc sybsystemprocs..sp_autoconnect  
read by proc sybsystemprocs..sp_checknames  
read_written by proc sybsystemprocs..sp_dropserver  
read by proc sybsystemprocs..sp_helpexternlogin  
read by proc sybsystemprocs..sp_addexternlogin  
read by proc sybsystemprocs..sp_dropremotelogin  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_helpremotelogin  
read by proc sybsystemprocs..sp_defaultloc