Module org.jooq
Package org.jooq

Interface Constraint

All Superinterfaces:
FieldOrConstraint, Named, QueryPart, Serializable, TableElement
All Known Subinterfaces:
ConstraintEnforcementStep, ConstraintFinalStep, ConstraintForeignKeyOnStep, ConstraintTypeStep, QOM.Check, QOM.ForeignKey, QOM.PrimaryKey, QOM.UniqueKey

public non-sealed interface Constraint extends FieldOrConstraint, TableElement
A DDL constraint.

Constraint definitions can be used in DDL statements in order to specify the constraint, or in some DML statements that reference a given constraint.

Example:


 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .alterTable(ACTOR)
    .add(constraint("actor_unique_name")
        .unique(ACTOR.FIRST_NAME, ACTOR.LAST_NAME))
    .execute();
 

Instances can be created using DSL.constraint(Name) and overloads.

Author:
Lukas Eder