SQL Reference Guide > SQL Reference Guide > SQL Statements > MODIFY > MODIFY…TO ENCRYPT
Was this helpful?
MODIFY…TO ENCRYPT
The MODIFY…TO ENCRYPT statement enables or disables access to a table with encrypted columns or changes the passphrase for a table with encrypted columns.
Syntax to enable access to a table with encrypted columns:
MODIFY tablename TO ENCRYPT
WITH PASSPHRASE='encryption passphrase'
Syntax to disable access to a table with encrypted columns:
MODIFY tablename TO ENCRYPT
WITH PASSPHRASE=''
Syntax to change the passphrase for a table with encrypted columns:
MODIFY tablename TO ENCRYPT
WITH PASSPHRASE='encryption passphrase',
NEW_PASSPHRASE='new encryption passphrase'
Last modified date: 11/09/2022