The sysviolations system catalog table stores information about the constraint violations for base tables. Every table in the database that has a violations table and a diagnostics table associated with it has a corresponding row in the sysviolations table, which has the following columns.
The maxrows column also signifies the maximum number of rows that can be inserted in the diagnostics table during a single operation that enables a disabled object or that sets a disabled object to filtering mode (provided that a diagnostics table exists for the target table). If no maximum is specified for the diagnostics or violations table, then maxrows contains a NULL value.
Extended Parallel Server does not use the diagnostic table when a constraint violation occurs. Rather, the database server stores additional information in the violations table. The violations table contains the data that the transaction refused and an indication of the cause.
The primary key of this table is the targettid column. An additional unique index is also defined on the viotid column.
Dynamic Server also has a unique index on the diatid column.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]