Database | Table | Application | Created | Links |
sybsystemprocs | syskeys ![]() | ![]() | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table syskeys(-- 0 Rows, Data: 0 B, Index: 0 B 2 id int not null, 3 type smallint not null, 4 depid int null, 5 keycnt int null, 6 size int null, 7 key1 smallint null, 8 key2 smallint null, 9 key3 smallint null, 10 key4 smallint null, 11 key5 smallint null, 12 key6 smallint null, 13 key7 smallint null, 14 key8 smallint null, 15 depkey1 smallint null, 16 depkey2 smallint null, 17 depkey3 smallint null, 18 depkey4 smallint null, 19 depkey5 smallint null, 20 depkey6 smallint null, 21 depkey7 smallint null, 22 depkey8 smallint null, 23 spare1 smallint not null 24 ) 25 26 create clustered index csyskeys on syskeys(-- 2 KB refcount: 22 27 id 28 ) 29 30 alter table syskeys lock datarows 31 32 Grant Select on syskeys to public 33
JOINS | ||||||||||||
|
Estimated Index Usage | |
syskeys.csyskeys clustered(id) | 22 |
ALIASES USED for sybsystemprocs..syskeys | ||
NO_ALIAS | k | syskeys |
17 | 2 | 5 |
SCHEMA |
![]() |
QUERIES | |
Joined With | Links |
master..spt_values | sybsystemprocs..sp_helpkey:132 |
sybsystemprocs..sp_helpkey:71 |
DEPENDENCIES |
READERS AND WRITERS read by proc sybsystemprocs..sp_helpkey ![]() called by proc sybsystemprocs..sp_help ![]() read_written by proc sybsystemprocs..sp_primarykey ![]() read_written by proc sybsystemprocs..sp_foreignkey ![]() read by proc sybsystemprocs..sp_helpjoins ![]() read by proc sybsystemprocs..sp_depends_cols ![]() called by proc sybsystemprocs..sp_depends ![]() read_written by proc sybsystemprocs..sp_commonkey ![]() written by proc sybsystemprocs..sp_dropkey ![]() |