Table Constraints¶

Delta Lake allows for table constraints using the following SQL statements:

• ALTER TABLE ADD CONSTRAINT
• ALTER TABLE DROP CONSTRAINT

Table constraints can be one of the following:

• Column-Level Invariants
• Table-Level Check Constraints
• Generated Columns Constraints

Column-level invariants require Protocol to be at least 2 for the writer version.

DeltaCatalog is used to add or remove constraints of a delta table (using AddConstraint and DropConstraint).

References¶

• Constraints