Use the STOP VIOLATIONS TABLE statement to drop the association between a target table, its violations table, and its diagnostics table. This statement is an extension to the ANSI/ISO standard for SQL.


1  STOP VIOLATIONS TABLE FOR?   'owner'  . table
Element Description Restrictions Syntax
owner The owner of table Must own the table Owner name
table Name of a target table whose association with the violations and diagnostics table is to be dropped. No default value exists. Must be a local table that has an associated violations table and a diagnostics table Identifier


The STOP VIOLATIONS TABLE statement drops the association between the target table, the violations table, and the diagnostics table. After you issue this statement, the former violations and diagnostics tables continue to exist, but they no longer function as violations and diagnostics tables for the target table. They now have the status of regular database tables instead of violations and diagnostics tables for the target table. You must issue the DROP TABLE statement to drop these two tables explicitly.

When DML operations (INSERT, DELETE, or UPDATE) cause data-integrity violations for rows of the target table, the nonconforming rows are no longer filtered to the former violations table, and diagnostic information about the data-integrity violations is not placed in the former diagnostics table.