Altering Constraint Enforcement

To alter how Vertica enforces constraints, use the ALTER TABLE clause ALTER CONSTRAINT. You must qualify this clause with the keyword ENABLED or DISABLED:

• ENABLED automatically enforces a primary key, unique key or check constraint.
• DISABLED prevents automatic enforcement of a primary key, unique key or check constraint.

For more information on automatic constraint enforcement, see Enforcing Primary Key, Unique Key, and Check Constraints Automatically

If you disable automatic enforcement of primary or unique key constraints, you can instead run ANALYZE_CONSTRAINTS to verify that columns have unique values after running a DML command or bulk loading. In the case of check constraints, you can use ANALYZE_CONSTRAINTS to validate check constraint conditions.

See About Constraints for general information about constraints.