Drops a column master key from a database. This is a metadata operation.
Transact-SQL Syntax Conventions
DROP COLUMN MASTER KEY key_name;
key_name
The name of the column master key.
The column master key can only be dropped if there are no column encryption key values encrypted with the column master key. To drop column encryption key values, use the DROP COLUMN ENCRYPTION KEY statement.
Requires ALTER ANY COLUMN MASTER KEY permission on the database.
The following example drops a column master key called MyCMK
.
DROP COLUMN MASTER KEY MyCMK;
GO
CREATE COLUMN MASTER KEY (Transact-SQL)
CREATE COLUMN ENCRYPTION KEY (Transact-SQL)
DROP COLUMN ENCRYPTION KEY (Transact-SQL)
Always Encrypted (Database Engine)
sys.column_master_keys (Transact-SQL)