Database | Table | Application | Created | Links |
sybsystemprocs | sysusers | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysusers(-- 18 Rows, Data: 2 KB, Index: 8 KB 2 suid int not null, 3 uid int not null, 4 gid int not null, 5 name sysname not null, 6 environ varchar(255) null 7 ) 8 9 create unique index ncsysusers1 on sysusers(-- 2 KB refcount: 35 10 name 11 ) 12 create unique index ncsysusers2 on sysusers(-- 2 KB refcount: 87 13 uid 14 ) 15 create clustered index csysusers on sysusers(-- 2 KB refcount: 15 16 suid 17 ) 18 19 alter table sysusers lock datarows 20 21 Grant Select on sysusers to public 22
JOINS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Estimated Index Usage | |
sysusers.ncsysusers2 unique(uid) | 87 |
sysusers.ncsysusers1 unique(name) | 35 |
sysusers.csysusers clustered(suid) | 15 |
ALIASES USED for sybsystemprocs..sysusers | |||||||||
G | NO_ALIAS | b | g | s | su | sysusers | u | u1 | u2 |
1 | 68 | 1 | 5 | 2 | 14 | 4 | 40 | 2 | 9 |
SCHEMA |