Example of a Violations Table

To start a violations and diagnostics table for the target table named customer in the demonstration database, enter the following statement:

START VIOLATIONS TABLE FOR customer

Because you include no USING clause, the violations table is named customer_vio by default. The customer_vio table includes these columns:

The customer_vio table has the same table definition as the customer table except that the customer_vio table has three additional columns that contain information about the operation that caused the nonconforming row.