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 ![]() |