public interface AlterDomainStep<T>
A step in the construction of the Referencing
ALTER DOMAIN
statement.
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:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
-
Method Summary
Modifier and TypeMethodDescription@NotNull AlterDomainFinalStep
add
(Constraint addConstraint) Add theADD
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraint
(String dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraint
(Constraint dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraint
(Name dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraintIfExists
(String dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraintIfExists
(Constraint dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainDropConstraintCascadeStep
dropConstraintIfExists
(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theDROP DEFAULT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theDROP NOT NULL
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraint
(String renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraint
(Constraint renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraint
(Name renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraintIfExists
(String renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraintIfExists
(Constraint renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainRenameConstraintStep
renameConstraintIfExists
(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theRENAME TO
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theRENAME TO
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theRENAME TO
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
setDefault
(Field<T> setDefault) Add theSET DEFAULT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
setDefault
(T setDefault) Add theSET DEFAULT
clause to theALTER DOMAIN
statement.@NotNull AlterDomainFinalStep
Add theSET NOT NULL
clause to theALTER DOMAIN
statement.
-
Method Details
-
add
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep add(Constraint addConstraint) Add theADD
clause to theALTER DOMAIN
statement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(@Name String dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Name dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Constraint dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(@Name String dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Constraint dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(@Name String renameTo) Add theRENAME TO
clause to theALTER DOMAIN
statement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(Name renameTo) Add theRENAME TO
clause to theALTER DOMAIN
statement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(Domain<?> renameTo) Add theRENAME TO
clause to theALTER DOMAIN
statement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(@Name String renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(Name renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(Constraint renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(@Name String renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Constraint renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement. -
setDefault
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep setDefault(T setDefault) Add theSET DEFAULT
clause to theALTER DOMAIN
statement.- Parameters:
setDefault
- is wrapped asDSL.val(Object)
.
-
setDefault
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep setDefault(Field<T> setDefault) Add theSET DEFAULT
clause to theALTER DOMAIN
statement. -
dropDefault
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep dropDefault()Add theDROP DEFAULT
clause to theALTER DOMAIN
statement. -
setNotNull
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep setNotNull()Add theSET NOT NULL
clause to theALTER DOMAIN
statement. -
dropNotNull
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep dropNotNull()Add theDROP NOT NULL
clause to theALTER DOMAIN
statement.
-