public interface AlterTableAlterStep<T>
ALTER TABLE
DSL used to ALTER
columns.Modifier and Type | Method and Description |
---|---|
AlterTableFinalStep |
defaultValue(Field<T> expression)
Specify a new column
DEFAULT . |
AlterTableFinalStep |
defaultValue(T literal)
Specify a new column
DEFAULT . |
AlterTableFinalStep |
dropNotNull()
Make the column nullable.
|
AlterTableFinalStep |
set(DataType<?> type)
Specify a new column data type.
|
AlterTableFinalStep |
setNotNull()
Make the column
NOT NULL . |
@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) AlterTableFinalStep defaultValue(T literal)
DEFAULT
.@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) AlterTableFinalStep defaultValue(Field<T> expression)
DEFAULT
.@Support(value={ACCESS,ASE,CUBRID,DB2,DERBY,H2,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE}) AlterTableFinalStep set(DataType<?> type)
This adds or removes NOT NULL
constraints on the column if
DataType.nullable()
is specified explicitly.
@Support(value={DB2,DERBY,H2,HSQLDB,POSTGRES}) AlterTableFinalStep setNotNull()
NOT NULL
.Copyright © 2018. All Rights Reserved.