Module org.jooq

Package org.jooq

Interface AlterTableStep

public interface AlterTableStep

The step in the 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 Type	Method	Description
AlterTableFinalStep	add(String field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	add(Collection<? extends FieldOrConstraint> fields)	Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.
AlterTableUsingIndexStep	add(Constraint constraint)	Add an ADD CONSTRAINT clause to the ALTER TABLE statement.
AlterTableFinalStep	add(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> AlterTableFinalStep	add(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	add(FieldOrConstraint... fields)	Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.
AlterTableFinalStep	add(Name field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumn(String field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumn(Field<?> field)	Add an ADD COLUMN clause to the ALTER TABLE statement.
<T> AlterTableFinalStep	addColumn(Field<T> field, DataType<T> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumn(Name field, DataType<?> type)	Add an ADD COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumnIfNotExists(String field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumnIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> AlterTableFinalStep	addColumnIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	addColumnIfNotExists(Name field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	addIfNotExists(String field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	addIfNotExists(Field<?> field)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
<T> AlterTableFinalStep	addIfNotExists(Field<T> field, DataType<T> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	addIfNotExists(Name field, DataType<?> type)	Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.
AlterTableAlterStep<Object>	alter(String field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
<T> AlterTableAlterStep<T>	alter(Field<T> field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
AlterTableAlterStep<Object>	alter(Name field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
AlterTableAlterStep<Object>	alterColumn(String field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
<T> AlterTableAlterStep<T>	alterColumn(Field<T> field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
AlterTableAlterStep<Object>	alterColumn(Name field)	Add an ALTER COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	comment(String comment)	Specify a comment for a table using MySQL's syntax.
AlterTableFinalStep	comment(Comment comment)	Specify a comment for a table using MySQL's syntax.
AlterTableDropStep	drop(String field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	drop(String... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	drop(Collection<? extends Field<?>> fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	drop(Constraint constraint)	Add a DROP CONSTRAINT clause to the ALTER TABLE statement.
AlterTableDropStep	drop(Field<?> field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	drop(Field<?>... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	drop(Name field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	drop(Name... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumn(String field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumn(Field<?> field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumn(Name field)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumnIfExists(String field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumnIfExists(Field<?> field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumnIfExists(Name field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumns(String... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumns(Collection<? extends Field<?>> fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumns(Field<?>... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableDropStep	dropColumns(Name... fields)	Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	dropConstraint(String constraint)	Add a DROP CONSTRAINT clause to the ALTER TABLE statement.
AlterTableFinalStep	dropConstraint(Constraint constraint)	Add a DROP CONSTRAINT clause to the ALTER TABLE statement.
AlterTableFinalStep	dropConstraint(Name constraint)	Add a DROP CONSTRAINT clause to the ALTER TABLE statement.
AlterTableFinalStep	dropForeignKey(String constraint)	Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.
AlterTableFinalStep	dropForeignKey(Constraint constraint)	Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.
AlterTableFinalStep	dropForeignKey(Name constraint)	Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.
AlterTableDropStep	dropIfExists(String field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableDropStep	dropIfExists(Field<?> field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableDropStep	dropIfExists(Name field)	Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.
AlterTableFinalStep	dropPrimaryKey()	Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.
AlterTableFinalStep	dropPrimaryKey(String constraint)	Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.
AlterTableFinalStep	dropPrimaryKey(Constraint constraint)	Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.
AlterTableFinalStep	dropPrimaryKey(Name constraint)	Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.
AlterTableRenameColumnToStep	renameColumn(String oldName)	Add a RENAME COLUMN clause to the ALTER TABLE statement.
AlterTableRenameColumnToStep	renameColumn(Field<?> oldName)	Add a RENAME COLUMN clause to the ALTER TABLE statement.
AlterTableRenameColumnToStep	renameColumn(Name oldName)	Add a RENAME COLUMN clause to the ALTER TABLE statement.
AlterTableRenameConstraintToStep	renameConstraint(String oldName)	Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.
AlterTableRenameConstraintToStep	renameConstraint(Constraint oldName)	Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.
AlterTableRenameConstraintToStep	renameConstraint(Name oldName)	Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.
AlterTableRenameIndexToStep	renameIndex(String oldName)	Add a RENAME INDEX clause to the ALTER TABLE statement.
AlterTableRenameIndexToStep	renameIndex(Index oldName)	Add a RENAME INDEX clause to the ALTER TABLE statement.
AlterTableRenameIndexToStep	renameIndex(Name oldName)	Add a RENAME INDEX clause to the ALTER TABLE statement.
AlterTableFinalStep	renameTo(String newName)	Add a RENAME TO clause to the ALTER TABLE statement.
AlterTableFinalStep	renameTo(Name newName)	Add a RENAME TO clause to the ALTER TABLE statement.
AlterTableFinalStep	renameTo(Table<?> newName)	Add a RENAME TO clause to the ALTER TABLE statement.

Method Detail

comment

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
AlterTableFinalStep comment(String comment)

Specify a comment for a table using MySQL's syntax.

See Also:

DSL.commentOnTable(Table), DSLContext.commentOnTable(Table)

comment

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA,VERTICA})
AlterTableFinalStep comment(Comment comment)

Specify a comment for a table using MySQL's syntax.

See Also:

DSL.commentOnTable(Table), DSLContext.commentOnTable(Table)

renameTo

@Support
AlterTableFinalStep renameTo(Table<?> newName)

Add a RENAME TO clause to the ALTER TABLE statement.

renameTo

@Support
AlterTableFinalStep renameTo(Name newName)

Add a RENAME TO clause to the ALTER TABLE statement.

renameTo

@Support
AlterTableFinalStep renameTo(String newName)

Add a RENAME TO clause to the ALTER TABLE statement.

renameColumn

@Support
AlterTableRenameColumnToStep renameColumn(Field<?> oldName)

Add a RENAME COLUMN clause to the ALTER TABLE statement.

renameColumn

@Support
AlterTableRenameColumnToStep renameColumn(Name oldName)

Add a RENAME COLUMN clause to the ALTER TABLE statement.

renameColumn

@Support
AlterTableRenameColumnToStep renameColumn(String oldName)

Add a RENAME COLUMN clause to the ALTER TABLE statement.

renameIndex

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,DERBY,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016})
AlterTableRenameIndexToStep renameIndex(Name oldName)

Add a RENAME INDEX clause to the ALTER TABLE statement.

renameIndex

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,DERBY,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016})
AlterTableRenameIndexToStep renameIndex(Index oldName)

Add a RENAME INDEX clause to the ALTER TABLE statement.

renameIndex

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,DERBY,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER2016})
AlterTableRenameIndexToStep renameIndex(String oldName)

Add a RENAME INDEX clause to the ALTER TABLE statement.

renameConstraint

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableRenameConstraintToStep renameConstraint(Constraint oldName)

Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.

renameConstraint

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableRenameConstraintToStep renameConstraint(Name oldName)

Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.

renameConstraint

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableRenameConstraintToStep renameConstraint(String oldName)

Add a RENAME CONSTRAINT clause to the ALTER TABLE statement.

alter

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
<T> AlterTableAlterStep<T> alter(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

This is an alias for alterColumn(Field).

alter

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
AlterTableAlterStep<Object> alter(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

This is an alias for alterColumn(Name)

alter

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
AlterTableAlterStep<Object> alter(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

This is an alias for alterColumn(String)

alterColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
<T> AlterTableAlterStep<T> alterColumn(Field<T> field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

alterColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
AlterTableAlterStep<Object> alterColumn(Name field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

alterColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,VERTICA})
AlterTableAlterStep<Object> alterColumn(String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

add

@Support
AlterTableFinalStep add(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

This is an alias for addColumn(Field).

add

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep add(FieldOrConstraint... fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

add

@Support({AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep add(Collection<? extends FieldOrConstraint> fields)

Add an ADD clause with multiple columns or constraints to the ALTER TABLE statement.

add

@Support
<T> AlterTableFinalStep add(Field<T> field,
                            DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

This is an alias for addColumn(Field, DataType).

add

@Support
AlterTableFinalStep add(Name field,
                        DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

This is an alias for addColumn(Name, DataType).

add

@Support
AlterTableFinalStep add(String field,
                        DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

This is an alias for addColumn(String, DataType).

addIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

This is an alias for addColumnIfNotExists(Field).

addIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
<T> AlterTableFinalStep addIfNotExists(Field<T> field,
                                       DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

This is an alias for addColumnIfNotExists(Field, DataType).

addIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addIfNotExists(Name field,
                                   DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

This is an alias for addColumnIfNotExists(Name, DataType).

addIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addIfNotExists(String field,
                                   DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

This is an alias for addColumnIfNotExists(String, DataType).

addColumn

@Support
AlterTableFinalStep addColumn(Field<?> field)

Add an ADD COLUMN clause to the ALTER TABLE statement.

addColumn

@Support
<T> AlterTableFinalStep addColumn(Field<T> field,
                                  DataType<T> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

addColumn

@Support
AlterTableFinalStep addColumn(Name field,
                              DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

addColumn

@Support
AlterTableFinalStep addColumn(String field,
                              DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

addColumnIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addColumnIfNotExists(Field<?> field)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

addColumnIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
<T> AlterTableFinalStep addColumnIfNotExists(Field<T> field,
                                             DataType<T> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

addColumnIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addColumnIfNotExists(Name field,
                                         DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

addColumnIfNotExists

@Support({AURORA_POSTGRES,DB2,H2,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableFinalStep addColumnIfNotExists(String field,
                                         DataType<?> type)

Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE statement.

add

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableUsingIndexStep add(Constraint constraint)

Add an ADD CONSTRAINT clause to the ALTER TABLE statement.

drop

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep drop(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumn(Field).

drop

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep drop(Name field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumn(Name).

drop

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep drop(String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumn(String).

dropIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropIfExists(Field<?> field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

This is an alias for dropColumnIfExists(Field).

dropIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropIfExists(Name field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

This is an alias for dropColumnIfExists(Name).

dropIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropIfExists(String field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

This is an alias for dropColumnIfExists(String).

dropColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep dropColumn(Field<?> field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep dropColumn(Name field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumn

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA})
AlterTableDropStep dropColumn(String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumnIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumnIfExists(Field<?> field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

dropColumnIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumnIfExists(Name field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

dropColumnIfExists

@Support({AURORA_POSTGRES,DB2,H2,MARIADB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumnIfExists(String field)

Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE statement.

drop

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep drop(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumns(Collection).

drop

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep drop(Name... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumns(Collection).

drop

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep drop(String... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumns(Collection).

dropColumns

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumns(Field<?>... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumns

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumns(Name... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumns

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumns(String... fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

drop

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep drop(Collection<? extends Field<?>> fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumns(Collection).

dropColumns

@Support({ASE,AURORA_MYSQL,AURORA_POSTGRES,DB2,FIREBIRD,H2,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,TERADATA})
AlterTableDropStep dropColumns(Collection<? extends Field<?>> fields)

Add an DROP COLUMN clause to the ALTER TABLE statement.

drop

@Support({ACCESS,ASE,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MEMSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep drop(Constraint constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

dropConstraint

@Support({ACCESS,ASE,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropConstraint(Constraint constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

See Also:

DSL.constraint(String)

dropConstraint

@Support({ACCESS,ASE,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropConstraint(Name constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

See Also:

DSL.constraint(String)

dropConstraint

@Support({ACCESS,ASE,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropConstraint(String constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

See Also:

DSL.constraint(String)

dropPrimaryKey

@Support({AURORA_MYSQL,AURORA_POSTGRES,DERBY,H2,HSQLDB,MARIADB,MYSQL,POSTGRES})
AlterTableFinalStep dropPrimaryKey()

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

dropPrimaryKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropPrimaryKey(Constraint constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates DROP PRIMARY KEY as in dropPrimaryKey(). In other dialect families, this produces a DROP CONSTRAINT [name] clause, as in dropConstraint(Constraint).

dropPrimaryKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropPrimaryKey(Name constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates DROP PRIMARY KEY as in dropPrimaryKey(). In other dialect families, this produces a DROP CONSTRAINT [name] clause, as in dropConstraint(Name).

See Also:

DSL.constraint(Name)

dropPrimaryKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropPrimaryKey(String constraint)

Add a DROP PRIMARY KEY clause to the ALTER TABLE statement.

Dialect families derived from MySQL do not know named constraints, in case of which this clause simply generates DROP PRIMARY KEY as in dropPrimaryKey(). In other dialect families, this produces a DROP CONSTRAINT [name] clause, as in dropConstraint(String).

See Also:

DSL.constraint(String)

dropForeignKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropForeignKey(Constraint constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

dropForeignKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropForeignKey(Name constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

See Also:

DSL.constraint(Name)

dropForeignKey

@Support({ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
AlterTableFinalStep dropForeignKey(String constraint)

Add a DROP FOREIGN KEY clause to the ALTER TABLE statement.

See Also:

DSL.constraint(String)