Menu
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?):
241
Always Encrypted supports two types of encryption: randomized encryption and deterministic encryption. Deterministic encryption always generates the same encrypted value for any given plain text value. Using deterministic encryption allows point lookups, equality joins, grouping and indexing on encrypted columns.
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.
111
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
