Was this helpful?
ALTER KEYS
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ALTER KEYS statement changes the encryption key for data that is already stored in an encrypted database. You can change the table keys for all tables or specified tables.
This statement is valid only when connected to an encrypted database.
This statement has the following format:
[EXEC SQL] ALTER KEYS ON DATABASE
or
[EXEC SQL] ALTER KEYS ON TABLE table_name {, table_name}
ALTER KEYS ON DATABASE
Changes the encryption key for all tables in the encrypted database.
ALTER KEYS ON TABLE table_name {, table_name}
Changes the encryption key for the specified tables.
Related Statements
ALTER PASSPHRASE
Last modified date: 03/21/2024