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/28/2023