How to remove Always Encrypted from a column in SQL Server 2016
encryption, sql-server, sql-server-2016
Solution
The answer for question 1) is to run the Always Encrypted wizard again and select "Plaintext" as Encryption Type.
Side note: I had to remove a default value constraint on a bit column to make the wizard complete without errors.
Problem
How can I remove the encryption property from a column in SQL Server 2016? I've enabled this feature using the Always Encrypted wizard in SQL Server Management Studio 2016, but I would like to remove the encryption from some columns I've added before. I wonder if the following 2 things are possible (and if so how?): - Really undo the encryption using the certificate used for the encryption. - Remove the encryption and leave the encrypted data in the cells.