The SHOW COLUMN STATISTICS CIPHER statement retrieves the cipher currently used for encrypting and decrypting column statistics data, specifically for Transparent Data Encryption (TDE)-enabled tables that store sample column values.

Syntax

SHOW COLUMN STATISTICS CIPHER
When run, this statement displays the cipher currently used to encrypt column statistics for TDE-enabled tables.
Note:
  • You must have DBA privileges to run the SHOW COLUMN STATISTICS CIPHER statement.
  • If the cipher has not been explicitly changed, the command returns the default cipher, which is AES_CFB_128.
  • If the cipher has been changed using the ALTER DATABASE SET COLUMN STATISTICS command, the SHOW command returns the new cipher. For more information, see ALTER DATABASE SET COLUMN STATISTICS.

Example

In the following example, the SHOW COLUMN STATISTICS CIPHER command returns the default encryption cipher used for column statistics when no cipher has been changed using the ALTER DATABASE command:
SHOW COLUMN STATISTICS CIPHER
Output:
AES_CFB_128
In the following example, the SHOW COLUMN STATISTICS CIPHER command reflects the updated configuration if the cipher has been changed using the ALTER DATABASE command with the 'AES_CFB_256' cipher: 
ALTER DATABASE SET COLUMN STATISTICS CIPHER 'AES_CFB_256'; 

--Statistics re-encrypted 

SHOW COLUMN STATISTICS CIPHER;

Output:

Displays the updated cipher: AES_CFB_256, confirming that the column statistics have been re-encrypted using the new cipher:
AES_CFB_256