About Constraints

Constraints specify rules on what values can go into a column. Examples of constraints:

• Primary key
• Foreign key
• Unique
• Check
• Not NULL

Using constraints can help you maintain data integrity in one or more columns. Do not define constraints on columns unless you expect to keep the data consistent.

Vertica can use constraints to perform optimizations (such as the optimized MERGE) that assume the data is consistent.