如何从SQL Server 2016中的列中删除始终加密 [英] How to remove Always Encrypted from a column in SQL Server 2016

问题描述

如何从SQL Server 2016的列中删除加密属性?

How can I remove the encryption property from a column in SQL Server 2016?

我已使用SQL Server Management Studio 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?):

1. 使用用于加密的证书真正撤消加密.
2. 删除加密并将加密的数据保留在单元格中.

推荐答案

问题1的答案是再次运行始终加密"向导，然后选择纯文本"作为加密类型".

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.

这篇关于如何从SQL Server 2016中的列中删除始终加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！