DatabaseTableApplicationCreatedLinks
sybsystemprocssysencryptkeys  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysencryptkeys(-- 27 Rows, Data: 2 KB, Index: 2 KB
2         id int not null,
3         ekalgorithm int not null,
4         type smallint not null,
5         status int not null,
6         eklen smallint not null,
7         value varbinary(1282) not null,
8         uid int null,
9         eksalt varbinary(20) null,
10        ekpairid int null,
11        pwdate datetime null,
12        expdate int null,
13        ekpwdwarn int null
14    )
15    
16    create unique clustered index csysencryptkeys on sysencryptkeys(-- 2 KB refcount: 39
17        id, type, uid
18    )
19    
20    alter table sysencryptkeys lock datarows
21    
22    Grant Select on sysencryptkeys to sso_role
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]40 FK
[uid]sybsystemprocs..sysusers[uid]4 FK

Estimated Index Usage
sysencryptkeys.csysencryptkeys unique clustered(id, type, uid)39

ALIASES USED for sybsystemprocs..sysencryptkeys
NO_ALIASee1sysencryptkeys
14161

SCHEMA

COLUMN USAGE
idsp_aux_encrkey_info  sp_aux_encr_verify_downgrade  sp_encryption 
ekalgorithmsp_aux_encrkey_info 
typesp_aux_encrkey_info  sp_aux_encr_verify_downgrade  sp_encryption 
statussp_aux_encrkey_info  sp_aux_encr_verify_downgrade  sp_encryption 
eklensp_aux_encrkey_info 
uidsp_aux_encr_verify_downgrade  sp_dropuser  sp_encryption 
eksaltsp_aux_encr_verify_downgrade 
pwdatesp_encryption 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_aux_encr_verify_downgrade:527
sybsystemprocs..sp_encryption:1956
sybsystemprocs..sp_encryption:2339
sybsystemprocs..sp_aux_encr_verify_downgrade:460
sybsystemprocs..sp_encryption:989
sybsystemprocs..sp_encryption:1887
sybsystemprocs..sp_encryption:738
sybsystemprocs..sp_aux_encr_verify_downgrade:90
sybsystemprocs..sp_aux_encr_verify_downgrade:166
sybsystemprocs..sp_aux_encr_verify_downgrade:125
sybsystemprocs..sp_aux_encr_verify_downgrade:536
sybsystemprocs..sp_encryption:2694
sybsystemprocs..sp_encryption:2539
sybsystemprocs..sp_encryption:2619
sybsystemprocs..sp_encryption:2400
sybsystemprocs..sp_encryption:764
sybsystemprocs..sp_aux_encrkey_info:47
sybsystemprocs..sp_encryption:2464

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_aux_encrkey_info  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade