Each key created in a database, including the default key,
has an entry in the database-specific system catalog sysencryptkeys.
Table 5: sysencryptkeys
Field
Type
Description
id
int
Encryption key ID
ekalgorithm
int
Encryption algorithm
type
smallint
Identifies the key type. The values are EK_SYMMETRIC and EK_DEFAULT.
status
int
Internal status information
eklen
smallint
User-specified length of key
value
varbinary(1282)
Encrypted value of a key. contains a symmetric
encryption of the key. To encrypt keys, Adaptive Server uses AES with
a 128-bit key from the system encryption password.
uid
int null
Not used
eksalt
varbinary(20)
Contains random salt used to validate decryption
of the encryption key.
