| Package | Description | 
|---|---|
| org.jooq | The  org.jooqpackage contains jOOQ's public API. | 
| Modifier and Type | Interface and Description | 
|---|---|
| interface  | ConstraintFinalStepThe final step in the  Constraintconstruction DSL API. | 
| interface  | ConstraintForeignKeyOnStepThe step in the  Constraintconstruction DSL API that allows for
 addingON DELETEandON UPDATEclauses. | 
| interface  | ConstraintTypeStepThe step in the  Constraintconstruction DSL API that allows for
 specifying the constraint type. | 
| Modifier and Type | Method and Description | 
|---|---|
| Constraint | Key. constraint()Get this  KEYas a formalConstraintspecification. | 
| Modifier and Type | Method and Description | 
|---|---|
| AlterTableUsingIndexStep | AlterTableStep. add(Constraint constraint)Add an  ADD CONSTRAINTclause to theALTER TABLEstatement. | 
| CreateTableConstraintStep | CreateTableConstraintStep. constraint(Constraint constraint)Add a constraint to the table. | 
| CreateTableConstraintStep | CreateTableConstraintStep. constraints(Constraint... constraints)Add constraints to the table. | 
| AlterTableFinalStep | AlterTableStep. drop(Constraint constraint)Add a  DROP CONSTRAINTclause to theALTER TABLEstatement. | 
| void | InsertQuery. onConflictOnConstraint(Constraint constraint)Whether use a  On CONFLICTorON CONFLICT ON CONSTRAINTclause in thisINSERTstatement. | 
| InsertOnConflictDoUpdateStep<R> | InsertOnDuplicateStep. onConflictOnConstraint(Constraint constraint)Add a  ON CONFLICT ON CONSTRAINTclause to this query. | 
| AlterTableRenameConstraintToStep | AlterTableStep. renameConstraint(Constraint oldName)Add a  RENAME CONSTRAINTclause to theALTER TABLEstatement. | 
| AlterTableFinalStep | AlterTableRenameConstraintToStep. to(Constraint newName)Specify a new constraint name. | 
| Modifier and Type | Method and Description | 
|---|---|
| CreateTableConstraintStep | CreateTableConstraintStep. constraints(Collection<? extends Constraint> constraints)Add constraints to the table. | 
Copyright © 2019. All rights reserved.