Top Description Methods
org.jooq

public Interface ConstraintForeignKeyOnStep

extends ConstraintEnforcementStep
Known Direct Implementers
org.jooq.impl.ConstraintImpl
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

Deprecated

as a consequence of ConstraintEnforcementStep being deprecated. See corresponding docs for further information.

The step in the Constraint construction DSL API that allows for adding ON DELETE and ON UPDATE clauses.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull ConstraintForeignKeyOnStep
onDeleteCascade()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON DELETE CASCADE clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onDeleteNoAction()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON DELETE NO ACTION clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onDeleteRestrict()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON DELETE RESTRICT clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onDeleteSetDefault()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON DELETE SET DEFAULT clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onDeleteSetNull()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON DELETE SET NULL clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onUpdateCascade()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON UPDATE CASCADE clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onUpdateNoAction()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON UPDATE NO ACTION clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onUpdateRestrict()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON UPDATE RESTRICT clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onUpdateSetDefault()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON UPDATE SET DEFAULT clause to the FOREIGN KEY constraint.
public @NotNull ConstraintForeignKeyOnStep
onUpdateSetNull()

Deprecated as a consequence of ConstraintForeignKeyOnStep being deprecated.
Add an ON UPDATE SET NULL clause to the FOREIGN KEY constraint.
Inherited from org.jooq.ConstraintEnforcementStep:
enforcednotEnforced

Method Detail

onDeleteCascadeback to summary
public @NotNull ConstraintForeignKeyOnStep onDeleteCascade()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON DELETE CASCADE clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onDeleteNoActionback to summary
public @NotNull ConstraintForeignKeyOnStep onDeleteNoAction()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON DELETE NO ACTION clause to the FOREIGN KEY constraint.

This is the standard action according to the SQL standard. If a given SQLDialect does not support setting this action explicitly, no explicit action will be specified and calling this method is equivalent to not calling any method at all.

Annotations
@NotNull
@Support
onDeleteRestrictback to summary
public @NotNull ConstraintForeignKeyOnStep onDeleteRestrict()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON DELETE RESTRICT clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onDeleteSetDefaultback to summary
public @NotNull ConstraintForeignKeyOnStep onDeleteSetDefault()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON DELETE SET DEFAULT clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, HSQLDB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onDeleteSetNullback to summary
public @NotNull ConstraintForeignKeyOnStep onDeleteSetNull()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON DELETE SET NULL clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onUpdateCascadeback to summary
public @NotNull ConstraintForeignKeyOnStep onUpdateCascade()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON UPDATE CASCADE clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onUpdateNoActionback to summary
public @NotNull ConstraintForeignKeyOnStep onUpdateNoAction()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON UPDATE NO ACTION clause to the FOREIGN KEY constraint.

This is the standard action according to the SQL standard. If a given SQLDialect does not support setting this action explicitly, no explicit action will be specified and calling this method is equivalent to not calling any method at all.

Annotations
@NotNull
@Support
onUpdateRestrictback to summary
public @NotNull ConstraintForeignKeyOnStep onUpdateRestrict()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON UPDATE RESTRICT clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onUpdateSetDefaultback to summary
public @NotNull ConstraintForeignKeyOnStep onUpdateSetDefault()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON UPDATE SET DEFAULT clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, HSQLDB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
onUpdateSetNullback to summary
public @NotNull ConstraintForeignKeyOnStep onUpdateSetNull()

Deprecated

as a consequence of ConstraintForeignKeyOnStep being deprecated. See corresponding docs for further information.

Add an ON UPDATE SET NULL clause to the FOREIGN KEY constraint.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB