org.jooq

Interface AlterTableStep

public interface AlterTableStep

The step in the ALTER TABLE where the action can be decided.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
AlterTableFinalStep	add(Constraint constraint) Add an ADD CONSTRAINT 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(java.lang.String field, DataType<?> type) 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(java.lang.String field, DataType<?> type) Add an ADD 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<java.lang.Object>	alter(java.lang.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<java.lang.Object>	alterColumn(java.lang.String field) Add an ALTER 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(java.lang.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(java.lang.String field) Add an DROP COLUMN clause to the ALTER TABLE statement.
AlterTableFinalStep	dropConstraint(java.lang.String constraint) Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

Method Detail

alter

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
<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(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
AlterTableAlterStep<java.lang.Object> alter(java.lang.String field)

Add an ALTER COLUMN clause to the ALTER TABLE statement.

This is an alias for alterColumn(String)

alterColumn

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

Add an ALTER COLUMN clause to the ALTER TABLE statement.

alterColumn

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
AlterTableAlterStep<java.lang.Object> alterColumn(java.lang.String field)

Add an ALTER COLUMN clause 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(java.lang.String field,
                                  DataType<?> type)

Add an ADD COLUMN clause to the ALTER TABLE statement.

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

addColumn

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

Add an ADD COLUMN clause to the ALTER TABLE statement.

add

@Support
AlterTableFinalStep add(Constraint constraint)

Add an ADD CONSTRAINT clause to the ALTER TABLE statement.

addColumn

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

Add an ADD COLUMN clause to the ALTER TABLE statement.

drop

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

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumn(Field).

drop

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
AlterTableDropStep drop(java.lang.String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

This is an alias for dropColumn(String).

dropColumn

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

Add an DROP COLUMN clause to the ALTER TABLE statement.

dropColumn

@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
AlterTableDropStep dropColumn(java.lang.String field)

Add an DROP COLUMN clause to the ALTER TABLE statement.

drop

@Support
AlterTableFinalStep drop(Constraint constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

dropConstraint

@Support
AlterTableFinalStep dropConstraint(java.lang.String constraint)

Add a DROP CONSTRAINT clause to the ALTER TABLE statement.

See Also:

DSL.constraint(String)