Delete views and triggers
When you delete the views and triggers associated with a table, the base table is renamed back to the original name, and applications can no longer seamlessly interact with any encrypted data in the column.
Prerequisite
The pdbctl utility must be installed. Refer to pdbctl utility documents for details.
Steps
To delete views and triggers associated with a table, run the following command:
./pdbctl deleteview -a <database_alias> -t <table_name>
Flags Description
The following table describes the flags and parameters associated with this command:
| Flag | Data Type | Description |
|---|---|---|
| -a | string | Database alias associated with the database user. |
| -h | Flag to view help for deleteview command. | |
| -t | string | Table name from which views and triggers will be deleted. |
| --verbose | Print verbose logs. |
Example
To delete views and triggers for the table Customer, run the following command:
./pdbctl deleteview -a demo -t CUSTOMERS ; echo $?
pdbctl deleteview -a demo -t CUSTOMERS ; echo $?
0
Here,
echo $checks the error code.0indicates successful deletion of views and triggers.
