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 AlterDomainFinalStepadd(Constraint addConstraint) Add theADDclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraint(String dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraint(Constraint dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraint(Name dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraintIfExists(String dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraintIfExists(Constraint dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainDropConstraintCascadeStepdropConstraintIfExists(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theDROP DEFAULTclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theDROP NOT NULLclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraint(String renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraint(Constraint renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraint(Name renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraintIfExists(String renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraintIfExists(Constraint renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainRenameConstraintSteprenameConstraintIfExists(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theRENAME TOclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theRENAME TOclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theRENAME TOclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepsetDefault(Field<T> setDefault) Add theSET DEFAULTclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepsetDefault(T setDefault) Add theSET DEFAULTclause to theALTER DOMAINstatement.@NotNull AlterDomainFinalStepAdd theSET NOT NULLclause to theALTER DOMAINstatement.
-
Method Details
-
add
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep add(Constraint addConstraint) Add theADDclause to theALTER DOMAINstatement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(@Name String dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Name dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement. -
dropConstraint
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Constraint dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(@Name String dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
dropConstraintIfExists
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Constraint dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(@Name String renameTo) Add theRENAME TOclause to theALTER DOMAINstatement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(Name renameTo) Add theRENAME TOclause to theALTER DOMAINstatement. -
renameTo
@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep renameTo(Domain<?> renameTo) Add theRENAME TOclause to theALTER DOMAINstatement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(@Name String renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(Name renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement. -
renameConstraint
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraint(Constraint renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(@Name String renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
renameConstraintIfExists
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Constraint renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement. -
setDefault
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep setDefault(T setDefault) Add theSET DEFAULTclause to theALTER DOMAINstatement.- 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 DEFAULTclause to theALTER DOMAINstatement. -
dropDefault
@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES,YUGABYTEDB}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep dropDefault()Add theDROP DEFAULTclause to theALTER DOMAINstatement. -
setNotNull
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep setNotNull()Add theSET NOT NULLclause to theALTER DOMAINstatement. -
dropNotNull
@Support({AURORA_POSTGRES,POSTGRES}) @NotNull @CheckReturnValue @NotNull AlterDomainFinalStep dropNotNull()Add theDROP NOT NULLclause to theALTER DOMAINstatement.
-