Example of Dropping the Violations and Diagnostics Tables
After you execute the STOP VIOLATIONS TABLE statement in the preceding
example, the cust_subset_vio and the cust_subset_dia tables
continue to exist, but they are no longer associated with the cust_subset table.
Instead they now have the status of regular database tables. To drop
these two tables, enter the following statements:
DROP TABLE cust_subset_vio; DROP TABLE cust_subset_dia;
If you had previously issued the DROP TABLE statement without the RESTRICT keyword to successfully drop the cust_subset table, then the statements above would not be necessary, because dropping the target table in cascade mode implicitly drops any associated violations table and diagnostics table.