Package org.h2.command.ddl
Class AlterTableAlterColumn
- java.lang.Object
-
- org.h2.command.Prepared
-
- org.h2.command.ddl.DefineCommand
-
- org.h2.command.ddl.SchemaCommand
-
- org.h2.command.ddl.CommandWithColumns
-
- org.h2.command.ddl.AlterTableAlterColumn
-
public class AlterTableAlterColumn extends CommandWithColumns
This class represents the statements ALTER TABLE ADD, ALTER TABLE ADD IF NOT EXISTS, ALTER TABLE ALTER COLUMN, ALTER TABLE ALTER COLUMN SELECTIVITY, ALTER TABLE ALTER COLUMN SET DEFAULT, ALTER TABLE ALTER COLUMN DROP DEFAULT, ALTER TABLE ALTER COLUMN DROP EXPRESSION, ALTER TABLE ALTER COLUMN SET NULL, ALTER TABLE ALTER COLUMN DROP NULL, ALTER TABLE ALTER COLUMN SET VISIBLE, ALTER TABLE ALTER COLUMN SET INVISIBLE, ALTER TABLE DROP COLUMN
-
-
Field Summary
-
Fields inherited from class org.h2.command.ddl.DefineCommand
transactional
-
Fields inherited from class org.h2.command.Prepared
create, parameters, prepareAlways, session, sqlStatement, sqlTokens
-
-
Constructor Summary
Constructors Constructor Description AlterTableAlterColumn(SessionLocal session, Schema schema)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description voidaddColumn(Column column)Add a column to this table.intgetType()Get the command type as defined in CommandInterfacevoidsetAddAfter(java.lang.String after)voidsetAddBefore(java.lang.String before)voidsetAddFirst()Add the column as the first column of the table.voidsetBooleanFlag(boolean booleanFlag)voidsetColumnsToRemove(java.util.ArrayList<Column> columnsToRemove)voidsetDefaultExpression(Expression defaultExpression)Set default or on update expression.voidsetIfNotExists(boolean ifNotExists)voidsetIfTableExists(boolean b)voidsetNewColumn(Column newColumn)voidsetOldColumn(Column oldColumn)voidsetSelectivity(Expression selectivity)voidsetTableName(java.lang.String tableName)voidsetType(int type)voidsetUsingExpression(Expression usingExpression)Set using expression.longupdate()Execute the statement.-
Methods inherited from class org.h2.command.ddl.CommandWithColumns
addConstraintCommand, changePrimaryKeysToNotNull, createConstraints, generateSequences, getPrimaryKey
-
Methods inherited from class org.h2.command.ddl.SchemaCommand
getSchema
-
Methods inherited from class org.h2.command.ddl.DefineCommand
isReadOnly, isRetryable, isTransactional, queryMeta, setTransactional
-
Methods inherited from class org.h2.command.Prepared
checkCanceled, checkParameters, collectDependencies, getCurrentRowNumber, getDatabase, getObjectId, getParameters, getPersistedObjectId, getPlanSQL, getPlanSQL, getSession, getSimpleSQL, getSQL, getSQLTokens, invalidateCachedResult, isCacheable, isQuery, isWithParamValues, needRecompile, prepare, query, setCommand, setCurrentRowNumber, setParameterList, setPersistedObjectId, setPrepareAlways, setRow, setSession, setSQL, setWithParamValues, toString
-
-
-
-
Constructor Detail
-
AlterTableAlterColumn
public AlterTableAlterColumn(SessionLocal session, Schema schema)
-
-
Method Detail
-
setIfTableExists
public void setIfTableExists(boolean b)
-
setTableName
public void setTableName(java.lang.String tableName)
-
setOldColumn
public void setOldColumn(Column oldColumn)
-
setAddFirst
public void setAddFirst()
Add the column as the first column of the table.
-
setAddBefore
public void setAddBefore(java.lang.String before)
-
setAddAfter
public void setAddAfter(java.lang.String after)
-
update
public long update()
Description copied from class:PreparedExecute the statement.
-
setType
public void setType(int type)
-
setSelectivity
public void setSelectivity(Expression selectivity)
-
setDefaultExpression
public void setDefaultExpression(Expression defaultExpression)
Set default or on update expression.- Parameters:
defaultExpression- default or on update expression
-
setUsingExpression
public void setUsingExpression(Expression usingExpression)
Set using expression.- Parameters:
usingExpression- using expression
-
setNewColumn
public void setNewColumn(Column newColumn)
-
getType
public int getType()
Description copied from class:PreparedGet the command type as defined in CommandInterface
-
setIfNotExists
public void setIfNotExists(boolean ifNotExists)
-
addColumn
public void addColumn(Column column)
Description copied from class:CommandWithColumnsAdd a column to this table.- Specified by:
addColumnin classCommandWithColumns- Parameters:
column- the column to add
-
setColumnsToRemove
public void setColumnsToRemove(java.util.ArrayList<Column> columnsToRemove)
-
setBooleanFlag
public void setBooleanFlag(boolean booleanFlag)
-
-