Each key created in a database, including the default key, has an entry in the database-specific system catalog 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 values used to validate decryption of the encryption key. |
ekpairid |
int null |
Not used. |
pwdate |
datetime null |
Not used. |
expdate |
int null |
Not used. |
ekpwdwarn |
int null |
Not used. |
