ALTER TABLE
statement where the action can be
decided.
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
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
add
(Collection<? extends TableElement> fields) Add anADD
clause with multiple columns or constraints to theALTER TABLE
statement.@NotNull AlterTableUsingIndexStep
add
(Constraint constraint) Add anADD CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
add
(TableElement... fields) Add anADD
clause with multiple columns or constraints to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addColumnIfNotExists
(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addColumnIfNotExists
(Field<?> field) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAddStep
addColumnIfNotExists
(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addColumnIfNotExists
(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addIfNotExists
(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addIfNotExists
(Field<?> field) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAddStep
addIfNotExists
(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
addIfNotExists
(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAlterStep<Object>
Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterConstraintStep
alter
(Constraint constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAlterStep<T>
Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterStep<Object>
Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterStep<Object>
alterColumn
(String field) Add anALTER COLUMN
clause to theALTER TABLE
statement.<T> @NotNull AlterTableAlterStep<T>
alterColumn
(Field<T> field) Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterStep<Object>
alterColumn
(Name field) Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterConstraintStep
alterConstraint
(String constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableAlterConstraintStep
alterConstraint
(Constraint constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableAlterConstraintStep
alterConstraint
(Name constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableFinalStep
Specify a comment for a table using MySQL's syntax.@NotNull AlterTableFinalStep
Specify a comment for a table using MySQL's syntax.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
drop
(Collection<? extends Field<?>> fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
drop
(Constraint constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumn
(String field) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumn
(Field<?> field) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumn
(Name field) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumnIfExists
(String field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumnIfExists
(Field<?> field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumnIfExists
(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumns
(String... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumns
(Collection<? extends Field<?>> fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumns
(Field<?>... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropColumns
(Name... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraint
(String constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraint
(Constraint constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraint
(Name constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraintIfExists
(String constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraintIfExists
(Constraint constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropConstraintIfExists
(Name constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropForeignKey
(String constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropForeignKey
(Constraint constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropForeignKey
(Name constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropIfExists
(String field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropIfExists
(Constraint constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropIfExists
(Field<?> field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropIfExists
(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropPrimaryKey
(String constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropPrimaryKey
(Constraint constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropPrimaryKey
(Name constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropUnique
(String constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropUnique
(Constraint constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
dropUnique
(Name constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.@NotNull AlterTableRenameColumnToStep
renameColumn
(String oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableRenameColumnToStep
renameColumn
(Field<?> oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableRenameColumnToStep
renameColumn
(Name oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableRenameConstraintToStep
renameConstraint
(String oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableRenameConstraintToStep
renameConstraint
(Constraint oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableRenameConstraintToStep
renameConstraint
(Name oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterTableRenameIndexToStep
renameIndex
(String oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement.@NotNull AlterTableRenameIndexToStep
renameIndex
(Index oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement.@NotNull AlterTableRenameIndexToStep
renameIndex
(Name oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.
-
Method Details
-
comment
@NotNull @CheckReturnValue @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableFinalStep comment(String comment) Specify a comment for a table using MySQL's syntax.- See Also:
-
comment
@NotNull @CheckReturnValue @Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,EXASOL,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableFinalStep comment(Comment comment) Specify a comment for a table using MySQL's syntax.- See Also:
-
renameTo
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableFinalStep renameTo(Table<?> newName) Add aRENAME TO
clause to theALTER TABLE
statement. -
renameTo
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableFinalStep renameTo(Name newName) Add aRENAME TO
clause to theALTER TABLE
statement. -
renameTo
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableFinalStep renameTo(String newName) Add aRENAME TO
clause to theALTER TABLE
statement. -
renameColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameColumnToStep renameColumn(Field<?> oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement. -
renameColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameColumnToStep renameColumn(Name oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement. -
renameColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameColumnToStep renameColumn(String oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement. -
renameIndex
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,DERBY,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016}) @NotNull AlterTableRenameIndexToStep renameIndex(Name oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement. -
renameIndex
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,DERBY,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016}) @NotNull AlterTableRenameIndexToStep renameIndex(Index oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement. -
renameIndex
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,DB2,DERBY,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016}) @NotNull AlterTableRenameIndexToStep renameIndex(String oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement. -
renameConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameConstraintToStep renameConstraint(Constraint oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement. -
renameConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameConstraintToStep renameConstraint(Name oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement. -
renameConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,H2,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableRenameConstraintToStep renameConstraint(String oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement. -
alter
@NotNull @CheckReturnValue @Support({DB2,MYSQL_8_0_19,ORACLE}) @NotNull AlterTableAlterConstraintStep alter(Constraint constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.This is an alias for
alterConstraint(Constraint)
. -
alter
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) <T> @NotNull AlterTableAlterStep<T> alter(Field<T> field) -
alter
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableAlterStep<Object> alter(Name field) -
alter
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableAlterStep<Object> alter(String field) -
alterColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) <T> @NotNull AlterTableAlterStep<T> alterColumn(Field<T> field) Add anALTER COLUMN
clause to theALTER TABLE
statement. -
alterColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableAlterStep<Object> alterColumn(Name field) Add anALTER COLUMN
clause to theALTER TABLE
statement. -
alterColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableAlterStep<Object> alterColumn(String field) Add anALTER COLUMN
clause to theALTER TABLE
statement. -
alterConstraint
@NotNull @CheckReturnValue @Support({DB2,MYSQL_8_0_19,ORACLE}) @NotNull AlterTableAlterConstraintStep alterConstraint(Constraint constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement. -
alterConstraint
@NotNull @CheckReturnValue @Support({DB2,MYSQL_8_0_19,ORACLE}) @NotNull AlterTableAlterConstraintStep alterConstraint(Name constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement. -
alterConstraint
@NotNull @CheckReturnValue @Support({DB2,MYSQL_8_0_19,ORACLE}) @NotNull AlterTableAlterConstraintStep alterConstraint(String constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement. -
add
-
add
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableAddStep add(TableElement... fields) Add anADD
clause with multiple columns or constraints to theALTER TABLE
statement. -
add
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableAddStep add(Collection<? extends TableElement> fields) Add anADD
clause with multiple columns or constraints to theALTER TABLE
statement. -
add
@NotNull @CheckReturnValue @Support <T> @NotNull AlterTableAddStep add(Field<T> field, DataType<T> type) Add anADD COLUMN
clause to theALTER TABLE
statement.This is an alias for
addColumn(Field, DataType)
. -
add
Add anADD COLUMN
clause to theALTER TABLE
statement.This is an alias for
addColumn(Name, DataType)
. -
add
Add anADD COLUMN
clause to theALTER TABLE
statement.This is an alias for
addColumn(String, DataType)
. -
addIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addIfNotExists(Field<?> field) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.This is an alias for
addColumnIfNotExists(Field)
. -
addIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) <T> @NotNull AlterTableAddStep addIfNotExists(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.This is an alias for
addColumnIfNotExists(Field, DataType)
. -
addIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.This is an alias for
addColumnIfNotExists(Name, DataType)
. -
addIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addIfNotExists(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.This is an alias for
addColumnIfNotExists(String, DataType)
. -
addColumn
Add anADD COLUMN
clause to theALTER TABLE
statement. -
addColumn
@NotNull @CheckReturnValue @Support <T> @NotNull AlterTableAddStep addColumn(Field<T> field, DataType<T> type) Add anADD COLUMN
clause to theALTER TABLE
statement. -
addColumn
@NotNull @CheckReturnValue @Support @NotNull AlterTableAddStep addColumn(Name field, DataType<?> type) Add anADD COLUMN
clause to theALTER TABLE
statement. -
addColumn
@NotNull @CheckReturnValue @Support @NotNull AlterTableAddStep addColumn(String field, DataType<?> type) Add anADD COLUMN
clause to theALTER TABLE
statement. -
addColumnIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addColumnIfNotExists(Field<?> field) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement. -
addColumnIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) <T> @NotNull AlterTableAddStep addColumnIfNotExists(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement. -
addColumnIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addColumnIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement. -
addColumnIfNotExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES_10,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableAddStep addColumnIfNotExists(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement. -
add
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableUsingIndexStep add(Constraint constraint) Add anADD CONSTRAINT
clause to theALTER TABLE
statement. -
drop
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Field<?> field) -
drop
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Name field) -
drop
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(String field) -
dropIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropIfExists(Field<?> field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.This is an alias for
dropColumnIfExists(Field)
. -
dropIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropIfExists(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.This is an alias for
dropColumnIfExists(Name)
. -
dropIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropIfExists(String field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.This is an alias for
dropColumnIfExists(String)
. -
dropColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumn(Field<?> field) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
dropColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumn(Name field) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
dropColumn
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD,H2,HANA,HSQLDB,IGNITE,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE_3_38,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumn(String field) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
dropColumnIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumnIfExists(Field<?> field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement. -
dropColumnIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumnIfExists(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement. -
dropColumnIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,HANA,IGNITE,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,TRINO,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumnIfExists(String field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement. -
drop
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Field<?>... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.This is an alias for
dropColumns(Collection)
. -
drop
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Name... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.This is an alias for
dropColumns(Collection)
. -
drop
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(String... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.This is an alias for
dropColumns(Collection)
. -
dropColumns
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumns(Field<?>... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
dropColumns
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumns(Name... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
dropColumns
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumns(String... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
drop
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Collection<? extends Field<?>> fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.This is an alias for
dropColumns(Collection)
. -
dropColumns
@NotNull @CheckReturnValue @Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,FIREBIRD,H2,HANA,IGNITE,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull AlterTableDropStep dropColumns(Collection<? extends Field<?>> fields) Add anDROP COLUMN
clause to theALTER TABLE
statement. -
drop
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep drop(Constraint constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement. -
dropConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraint(Constraint constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.- See Also:
-
dropConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraint(Name constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.- See Also:
-
dropConstraint
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraint(String constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.- See Also:
-
dropIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,MARIADB_10_4,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) @NotNull AlterTableDropStep dropIfExists(Constraint constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement. -
dropConstraintIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,MARIADB_10_4,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraintIfExists(Constraint constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.- See Also:
-
dropConstraintIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,MARIADB_10_4,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraintIfExists(Name constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.- See Also:
-
dropConstraintIfExists
@NotNull @CheckReturnValue @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,MARIADB_10_4,ORACLE,POSTGRES,SQLSERVER,YUGABYTEDB}) @NotNull AlterTableDropStep dropConstraintIfExists(String constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.- See Also:
-
dropPrimaryKey
@NotNull @CheckReturnValue @Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,DERBY,EXASOL,H2,HANA,HSQLDB,MARIADB,MYSQL,POSTGRES,SNOWFLAKE}) @NotNull AlterTableDropStep dropPrimaryKey()Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement. -
dropPrimaryKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull AlterTableDropStep dropPrimaryKey(Constraint constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates
DROP PRIMARY KEY
as indropPrimaryKey()
. In other dialect families, this produces aDROP CONSTRAINT [name]
clause, as indropConstraint(Constraint)
. -
dropPrimaryKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull AlterTableDropStep dropPrimaryKey(Name constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates
DROP PRIMARY KEY
as indropPrimaryKey()
. In other dialect families, this produces aDROP CONSTRAINT [name]
clause, as indropConstraint(Name)
.- See Also:
-
dropPrimaryKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull AlterTableDropStep dropPrimaryKey(String constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates
DROP PRIMARY KEY
as indropPrimaryKey()
. In other dialect families, this produces aDROP CONSTRAINT [name]
clause, as indropConstraint(String)
.- See Also:
-
dropUnique
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropUnique(Constraint constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.Some dialects (e.g.
SQLDialect.COCKROACHDB
) may not be able to drop constraints by name. If users specify the constraint type and the name, however, then the syntax can be emulated, e.g. usingDROP INDEX … CASCADE
. -
dropUnique
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropUnique(Name constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.Some dialects (e.g.
SQLDialect.COCKROACHDB
) may not be able to drop constraints by name. If users specify the constraint type and the name, however, then the syntax can be emulated, e.g. usingDROP INDEX … CASCADE
.- See Also:
-
dropUnique
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropUnique(String constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.Some dialects (e.g.
SQLDialect.COCKROACHDB
) may not be able to drop constraints by name. If users specify the constraint type and the name, however, then the syntax can be emulated, e.g. usingDROP INDEX … CASCADE
.- See Also:
-
dropForeignKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropForeignKey(Constraint constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement. -
dropForeignKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropForeignKey(Name constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.- See Also:
-
dropForeignKey
@NotNull @CheckReturnValue @Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull AlterTableDropStep dropForeignKey(String constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.- See Also:
-