Module org.jooq

Package org.jooq

Interface AlterDomainStep<T>

public interface AlterDomainStep<T>

A step in the construction of the 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 Type	Method	Description
@NotNull AlterDomainFinalStep	add(Constraint addConstraint)	Add the ADD clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraint(String dropConstraint)	Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraint(Constraint dropConstraint)	Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraint(Name dropConstraint)	Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraintIfExists(String dropConstraint)	Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraintIfExists(Constraint dropConstraint)	Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainDropConstraintCascadeStep	dropConstraintIfExists(Name dropConstraint)	Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	dropDefault()	Add the DROP DEFAULT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	dropNotNull()	Add the DROP NOT NULL clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraint(String renameConstraint)	Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraint(Constraint renameConstraint)	Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraint(Name renameConstraint)	Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraintIfExists(String renameConstraint)	Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraintIfExists(Constraint renameConstraint)	Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainRenameConstraintStep	renameConstraintIfExists(Name renameConstraint)	Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	renameTo(String renameTo)	Add the RENAME TO clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	renameTo(Domain<?> renameTo)	Add the RENAME TO clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	renameTo(Name renameTo)	Add the RENAME TO clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	setDefault(Field<T> setDefault)	Add the SET DEFAULT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	setDefault(T setDefault)	Add the SET DEFAULT clause to the ALTER DOMAIN statement.
@NotNull AlterDomainFinalStep	setNotNull()	Add the SET NOT NULL clause to the ALTER DOMAIN statement.

Method Detail

add

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep add(Constraint addConstraint)

Add the ADD clause to the ALTER DOMAIN statement.

dropConstraint

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraint(String dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

dropConstraint

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Name dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

dropConstraint

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraint(Constraint dropConstraint)

Add the DROP CONSTRAINT clause to the ALTER DOMAIN statement.

dropConstraintIfExists

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(String dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

dropConstraintIfExists

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Name dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

dropConstraintIfExists

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainDropConstraintCascadeStep dropConstraintIfExists(Constraint dropConstraint)

Add the DROP CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

renameTo

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep renameTo(String renameTo)

Add the RENAME TO clause to the ALTER DOMAIN statement.

renameTo

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep renameTo(Name renameTo)

Add the RENAME TO clause to the ALTER DOMAIN statement.

renameTo

@Support({AURORA_POSTGRES,FIREBIRD,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep renameTo(Domain<?> renameTo)

Add the RENAME TO clause to the ALTER DOMAIN statement.

renameConstraint

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraint(String renameConstraint)

Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.

renameConstraint

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraint(Name renameConstraint)

Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.

renameConstraint

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraint(Constraint renameConstraint)

Add the RENAME CONSTRAINT clause to the ALTER DOMAIN statement.

renameConstraintIfExists

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(String renameConstraint)

Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

renameConstraintIfExists

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Name renameConstraint)

Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

renameConstraintIfExists

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainRenameConstraintStep renameConstraintIfExists(Constraint renameConstraint)

Add the RENAME CONSTRAINT IF EXISTS clause to the ALTER DOMAIN statement.

setDefault

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep setDefault(T setDefault)

Add the SET DEFAULT clause to the ALTER DOMAIN statement.

setDefault

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep setDefault(Field<T> setDefault)

Add the SET DEFAULT clause to the ALTER DOMAIN statement.

dropDefault

@Support({AURORA_POSTGRES,FIREBIRD,HSQLDB,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep dropDefault()

Add the DROP DEFAULT clause to the ALTER DOMAIN statement.

setNotNull

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep setNotNull()

Add the SET NOT NULL clause to the ALTER DOMAIN statement.

dropNotNull

@Support({AURORA_POSTGRES,POSTGRES})
@NotNull
@NotNull AlterDomainFinalStep dropNotNull()

Add the DROP NOT NULL clause to the ALTER DOMAIN statement.