| Database | Table | Application | Created | Links |
| master | sysservers | ![]() | 31 Aug 14 | Joins 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 | ||||||||||||||||||||||||||||||||||||
|
| Estimated Index Usage | |
| sysservers.csysservers unique clustered(srvid) | 56 |
| sysservers.ncsysservers unique(srvname) | 52 |
| ALIASES USED for master..sysservers | ||
| NO_ALIAS | s | sysservers |
| 44 | 40 | 14 |
| SCHEMA |
![]() |
| 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 |