DROP COLUMN ENCRYPTION KEY

说明

删除全密态列加密密钥

语法

drop_column_encryption_key ::=

drop_column_encryption_key::=
    DROP COLUMN ENCRYPTION KEY cek_name;

参数

cek_name

列加密密钥名称。

示例

示例: 删除列加密密钥

--  清理环境
DROP COLUMN ENCRYPTION KEY CEK119216;
DROP COLUMN MASTER KEY cmk119216;

create column master key CMK119216 with (KEY_STORE_PROVIDER_NAME = 'JAVA_KEYSTORE', KEY_PATH = 'E:\fork');
create column encryption key CEK119216 with values(COLUMN_MASTER_KEY = 'CMK119216',ALGORITHM = 'SM4',ENCRYPTED_VALUE = '0x01123125415132');


--  清理环境
DROP COLUMN ENCRYPTION KEY CEK119216;
DROP COLUMN MASTER KEY cmk119216;