Delete Views and Triggers
When the views and triggers associated with a table are deleted, the base table is renamed back to the original name, and applications are no longer able to seamlessly interact with any encrypted data in the column.
Executing INSERT, UPDATE, or DELETE statements on the table after deleting the views and triggers but before u nencrypting the table can lead to data loss. Make sure to recreate the views and triggers before executing these statements.
To delete views and triggers associated with a table:
Log on to the CipherTrust Manager GUI.
Click Database Protection to open the application. The Databases screen displays the list of existing database connections, if any.
Click the desired database connection.
Click the Tables link.
On the Authorize Database screen, enter the Database Password to access the tables.
Under the Tables with Encrypted Columns section, click the table for which you want delete views and triggers.
From the Table Actions drop-down list, select Delete Views and Triggers. On the Delete Views and Triggers for < table name > wizard:
Preview the SQL code to be executed. This code can’t be edited. This SQL code will be executed on the database.
The Perform Operation screen shows the progress of the operation. A message The views and triggers were successfully deleted. Close the window to return to the list is displayed on the screen.
- Click Close.