Integrity constraint violations occur when an insert, update, or delete statement violates a primary key, foreign key, check, or unique constraint or a unique index.
|
Message |
Value |
Description |
|---|---|---|
|
Attempt to insert duplicate key row in object object_name with unique index index_name. |
23000 |
Occurs when a duplicate row is inserted into a table that has a unique constraint or index. |
|
Check constraint violation occurred, dbname = database_name, table name = table_name, constraint name = constraint_name. |
23000 |
Occurs when an update or delete would violate a check constraint on a column. |
|
Dependent foreign key constraint violation in a referential integrity constraint. dbname = database_name, table name = table_name, constraint name = constraint_name. |
23000 |
Occurs when an update or delete on a primary key table would violate a foreign key constraint. |
|
Foreign key constraint violation occurred, dbname = database_name, table name = table_name, constraint name = constraint_name. |
23000 |
Occurs when an insert or update on a foreign key table is performed without a matching value in the primary key table. |