Dropping encryption

If you are a table owner, you can drop the encryption on a column by using alter table with the decrypt option.

The syntax is:

 drop encrypton key [database.[owner].]keyname

For example, drop encryption on the creditcard column in the customer table:

alter table customer modify creditcard decrypt