CHECK THIS OUT

https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-database-encryption-key-transact-sql

Remarks

If the database is encrypted, you must first remove encryption from the database by using the ALTER DATABASE statement. Wait for decryption to complete before removing the database encryption key. For more information about the ALTER DATABASE statement, see ALTER DATABASE SET Options (Transact-SQL). To view the state of the database, use the sys.dm_database_encryption_keys dynamic management view.

Permissions

Requires CONTROL permission on the database.

Examples

The following example removes the database encryption and drops the database encryption key.

With Regards,

hemen  parekh 

www.hemenparekh.in 

hcp@RecruitGuru.com 

( M ) +91 - 98,67,55,08,08