DatabaseTableApplicationCreatedLinks
sybsystemprocssysencryptkeys  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysencryptkeys(-- 0 Rows, Data: 2 KB, Index: 4 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    
17    create unique clustered index csysencryptkeys on sysencryptkeys(-- 2 KB refcount: 44
18        id, type, uid
19    )
20    
21    alter table sysencryptkeys lock datarows
22    
23    Grant Select on sysencryptkeys to sso_role
24    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]21 FK
[uid]sybsystemprocs..sysusers[uid]2 FK
[id]master..sysdatabases[encrkeyid]1 Simple Join

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

ALIASES USED for sybsystemprocs..sysencryptkeys
NO_ALIASee1sysencryptkeys
14171

SCHEMA

COLUMN USAGE
idsp_aux_encr_verify_downgrade  sp_aux_encrkey_info  sp_encryption 
ekalgorithmsp_aux_encrkey_info 
typesp_aux_encr_verify_downgrade  sp_aux_encrkey_info  sp_encryption 
statussp_aux_encr_verify_downgrade  sp_aux_encrkey_info  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:125
sybsystemprocs..sp_encryption:2999
sybsystemprocs..sp_encryption:2630
sybsystemprocs..sp_encryption:2924
sybsystemprocs..sp_aux_encr_verify_downgrade:527
sybsystemprocs..sp_encryption:2073
sybsystemprocs..sp_encryption:2837
sybsystemprocs..sp_encryption:2163
sybsystemprocs..sp_aux_encrkey_info:44
sybsystemprocs..sp_encryption:1055
sybsystemprocs..sp_encryption:2691
sybsystemprocs..sp_aux_encr_verify_downgrade:90
sybsystemprocs..sp_aux_encr_verify_downgrade:166
sybsystemprocs..sp_encryption:847
sybsystemprocs..sp_encryption:873
sybsystemprocs..sp_aux_encr_verify_downgrade:460
sybsystemprocs..sp_aux_encr_verify_downgrade:536
sybsystemprocs..sp_encryption:2762
master..sysdatabases sybsystemprocs..sysobjects sybsystemprocs..sp_encryption:2265

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