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 salt 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 |