Note
This view is available starting with V4.0.0.
Purpose
This view displays the encryption status of tables with encryption enabled in the current tenant. The system tenant cannot enable encryption.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The tenant ID. |
| TABLE_ID | bigint(20) | NO | The table ID. |
| TABLE_NAME | varchar(256) | NO | The table name. |
| TABLESPACE_ID | bigint(20) | NO | The tablespace ID. |
| ENCRYPTIONALG | varchar(30) | NO | The name of the encryption algorithm. The value can be
|
| ENCRYPTED | varchar(3) | NO | Indicates whether the table is encrypted. The value can be
|
| ENCRYPTEDKEY | varchar(33) | NO | The encryption key encrypted by the primary key. |
| MASTERKEYID | bigint(20) unsigned | NO | The version of the primary key. |
| BLOCKS_ENCRYPTED | decimal(20,0) | NO | The number of encrypted macroblocks. |
| BLOCKS_DECRYPTED | decimal(21,0) | NO | The number of unencrypted macroblocks. |
| STATUS | varchar(10) | NO | The encryption status. The value can be
|
| CON_ID | bigint(20) | NO | The tenant ID. |
References
For more information about transparent data encryption, see Transparent data encryption.