drop-column-encryption-key-transact-sql.md

title	DROP COLUMN ENCRYPTION KEY (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	10/15/2019
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	DROP COLUMN ENCRYPTION DROP COLUMN ENCRYPTION KEY DROP_COLUMN_ENCRYPTION_TSQL DROP_COLUMN_ENCRYPTION_KEY_TSQL
dev_langs	TSQL
helpviewer_keywords	DROP COLUMN ENCRYPTION KEY statement column encryption key, drop
ms.assetid	86415302-1383-4d36-9fc7-f780831a2d37
author	jaszymas
ms.author	jaszymas

DROP COLUMN ENCRYPTION KEY (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asdw]

Drops a column encryption key from a database.

Transact-SQL Syntax Conventions

Syntax

  
DROP COLUMN ENCRYPTION KEY key_name [;]  

Arguments

key_name
Is the name by which the column encryption key to be dropped from the database.

Remarks

A column encryption key cannot be dropped if it is used to encrypt any column in the database. All columns using the column encryption key must first be dropped.

Permissions

Requires ALTER ANY COLUMN ENCRYPTION KEY permission on the database.

Examples

A. Dropping a column encryption key

The following example drops a column encryption key called MyCEK.

DROP COLUMN ENCRYPTION KEY MyCEK;  
GO  

See Also

CREATE COLUMN ENCRYPTION KEY (Transact-SQL)
ALTER COLUMN ENCRYPTION KEY (Transact-SQL)
CREATE COLUMN MASTER KEY (Transact-SQL)
Always Encrypted
Always Encrypted with secure enclaves
Overview of Key Management for Always Encrypted
Manage keys for Always Encrypted with secure enclaves