TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

DROP CRYPTOGRAPHIC PROVIDER (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Drops a cryptographic provider within SQL Server.

Topic link icon Transact-SQL Syntax Conventions

  
DROP CRYPTOGRAPHIC PROVIDER provider_name   

provider_name
Is the name of the Extensible Key Management provider.

To delete an Extensible Key Management (EKM) provider, all sessions that use the provider must be stopped.

An EKM provider can only be dropped if there are no credentials mapped to it.

If there are keys mapped to an EKM provider when it is dropped the GUIDs for the keys remain stored in SQL Server. If a provider is created later with the same key GUIDs, the keys will be reused.

Requires CONTROL permission on the symmetric key.

The following example drops a cryptographic provider called SecurityProvider.

/* First, disable provider to perform the upgrade.  
This will terminate all open cryptographic sessions. */  
ALTER CRYPTOGRAPHIC PROVIDER SecurityProvider   
SET ENABLED = OFF;  
GO  
/* Drop the provider. */  
DROP CRYPTOGRAPHIC PROVIDER SecurityProvider;  
GO  

Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
ALTER CRYPTOGRAPHIC PROVIDER (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft