DatabaseTableApplicationCreatedLinks
mastersysdevices  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysdevices(-- 6 Rows, Data: 2 KB, Index: 6 KB
2         low int not null,
3         high int not null,
4         status smallint not null,
5         cntrltype smallint not null,
6         name sysname not null,
7         phyname varchar(127) not null,
8         mirrorname varchar(127) null,
9         vdevno int not null,
10        crdate datetime null,
11        resizedate datetime null,
12        status2 int not null
13    )
14    
15    create unique clustered index csysdevices on sysdevices(-- 2 KB refcount: 52
16        name
17    )
18    create index ncsysdevices on sysdevices(-- 2 KB refcount: 30
19        vdevno
20    )
21    
22    alter table sysdevices lock datarows
23    
24    Grant Select on sysdevices to public
25    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[vdevno]master..sysusages[vdevno]60 Simple Join
[name]master..spt_values[name]4 Rev FK

Estimated Index Usage
sysdevices.csysdevices unique clustered(name)52
sysdevices.ncsysdevices(vdevno)30

ALIASES USED for master..sysdevices
NO_ALIAScddevesysdevicesv
264761152

SCHEMA

COLUMN USAGE
lowsp_addsegment  sp_addumpdevice  sp_extendsegment  sp_helpcache  sp_helpdevice  sp_plan_dbccdb 
highsp_addsegment  sp_addumpdevice  sp_extendsegment  sp_helpcache  sp_helpdevice  sp_plan_dbccdb 
statussp_addumpdevice  sp_configure  sp_ddlgen_database  sp_deviceattr  sp_diskdefault  sp_dropdevice  sp_dropsegment  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_plan_dbccdb  sp_sysmon  sp_volchanged 
cntrltypesp_addsegment  sp_addumpdevice  sp_extendsegment  sp_helpdevice  sp_logdevice  sp_plan_dbccdb 
namesp_addsegment  sp_addumpdevice  sp_checknames  sp_checkreswords  sp_ddlgen_database  sp_deviceattr  sp_diskdefault  sp_downgrade  sp_dropdevice  sp_dropsegment  sp_extendsegment  sp_helpcache  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_logdevice  sp_plan_dbccdb  sp_sysmon  sp_volchanged 
phynamesp_addumpdevice  sp_deviceattr  sp_helpcache  sp_helpdevice  sp_sysmon  sp_volchanged 
mirrornamesp_helpdevice 
vdevnosp_addsegment  sp_addumpdevice  sp_ddlgen_database  sp_dropdevice  sp_dropsegment  sp_extendsegment  sp_helpdb  sp_helpdevice  sp_helplog  sp_helpsegment  sp_logdevice  sp_plan_dbccdb  sp_sysmon 
status2sp_addumpdevice  sp_ddlgen_database  sp_deviceattr  sp_diskdefault  sp_downgrade  sp_dropdevice  sp_dropsegment  sp_helpcache  sp_helpdb  sp_helpdevice  sp_helpsegment 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:357
sybsystemprocs..sp_checkreswords:353
master..sysusages sybsystemprocs..sp_extendsegment:165
sybsystemprocs..sp_dropsegment:498
sybsystemprocs..sp_logdevice:208
sybsystemprocs..sp_helplog:40
sybsystemprocs..sp_extendsegment:182
sybsystemprocs..sp_helpsegment:151
sybsystemprocs..sp_addsegment:184
sybsystemprocs..sp_extendsegment:337
sybsystemprocs..sp_extendsegment:382
sybsystemprocs..sp_dropsegment:489
sybsystemprocs..sp_helpsegment:110
sybsystemprocs..sp_addsegment:171
sybsystemprocs..sp_logdevice:174
sybsystemprocs..sp_dropsegment:301
sybsystemprocs..sp_extendsegment:355
sybsystemprocs..sp_dropsegment:395
sybsystemprocs..sp_addsegment:334
sybsystemprocs..sp_dropsegment:282
sybsystemprocs..sp_logdevice:157
sybsystemprocs..sp_addsegment:222
sybsystemprocs..sp_dropsegment:320
sybsystemprocs..sp_logdevice:198
sybsystemprocs..sp_addsegment:154
sybsystemprocs..sp_dropsegment:375
master..sysdatabases master..sysusages sybsystemprocs..sp_dropdevice:107
sybsystemprocs..sp_dropdevice:86
sybsystemprocs..sp_plan_dbccdb:111
sybsystemprocs..sp_ddlgen_database:330
sybsystemprocs..sp_dropdevice:96
sybsystemprocs..sp_dropdevice:71

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helplog  
read by proc sybsystemprocs..sp_extendsegment  
read by proc sybsystemprocs..sp_addsegment  
read_written by proc sybsystemprocs..sp_addumpdevice  
read by proc sybsystemprocs..sp_helpdevice  
read by proc sybsystemprocs..sp_ddlgen_database  
read_written by proc sybsystemprocs..sp_dropdevice  
read_written by proc sybsystemprocs..sp_diskdefault  
read_written by proc sybsystemprocs..sp_deviceattr  
read by proc sybsystemprocs..sp_helpdb  
read by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_setlockpromote  
      called by proc sybsystemprocs..sp_setpglockpromote  
      called by proc sybsystemprocs..sp_setrowlockpromote  
read by proc sybsystemprocs..sp_helpsegment  
read by proc sybsystemprocs..sp_volchanged  
read by proc sybsystemprocs..sp_helpcache  
read by proc sybsystemprocs..sp_logdevice  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_downgrade