public class AlterTableCommand extends BaseAxionCommand
NOTE: Identity column can't be altered.
NOTE: Renaming column require cascade to drop constraints and indexes and then rename
TODO: ADD [COLUMN] .... [BEFORE
Constructor and Description |
---|
AlterTableCommand(java.lang.String theTableName,
boolean cascade) |
Modifier and Type | Method and Description |
---|---|
void |
addChildCommand(AxionCommand cmd) |
void |
addColumn(java.lang.String name,
java.lang.String type,
java.lang.String precision,
java.lang.String scale,
Selectable defaultValue,
java.lang.String generated) |
void |
alterColumn(java.lang.String name,
java.lang.String newName,
Selectable newDefault,
java.lang.Boolean dropDefault) |
void |
dropColumn(java.lang.String colName) |
boolean |
execute(Database db)
Executes an SQL statement that may return multiple results.
|
AxionResultSet |
executeQuery(Database database)
Unsupported
|
int |
executeUpdate(Database db)
Executes an SQL that may add, delete or modify zero or more rows within the
database, such as an INSERT, UPDATE or DELETE statement.
|
void |
setRenameTo(java.lang.String newName) |
assertNotReadOnly, attemptToConvertValue, bindAll, buildBindVariables, clearBindings, createResolveSelectableVisitor, executeQuery, getBindVariableIterator, getBindVariableIterator, getBindVariables, getBindVariableVisitor, getColIdentifierList, getCommitSize, getEffectedRowCount, getResultSet, getRowIterator, makeRowDecorator, populateDefaultValues, populateSequenceColumns, resolveGeneratedColumns, resolveGeneratedColumns, resolveSelectable, resolveSelectable, resolveSelectableList, resolveSelectableList, setBindVariableVisitor, setDeferAllConstraintIfRequired, setEffectedRowCount, setResultSet, updateGeneratedValues
public AlterTableCommand(java.lang.String theTableName, boolean cascade)
public void addChildCommand(AxionCommand cmd)
public void addColumn(java.lang.String name, java.lang.String type, java.lang.String precision, java.lang.String scale, Selectable defaultValue, java.lang.String generated)
public void alterColumn(java.lang.String name, java.lang.String newName, Selectable newDefault, java.lang.Boolean dropDefault)
public void dropColumn(java.lang.String colName)
public boolean execute(Database db) throws AxionException
AxionCommand
ResultSet
s were generated,
false otherwiseAxionException
Statement.execute(java.lang.String)
,
PreparedStatement.execute()
public AxionResultSet executeQuery(Database database) throws AxionException
ResultSet
AxionException
Statement.executeQuery(java.lang.String)
,
PreparedStatement.executeQuery()
public int executeUpdate(Database db) throws AxionException
AxionCommand
AxionException
Statement.executeUpdate(java.lang.String)
,
PreparedStatement.executeUpdate()
public void setRenameTo(java.lang.String newName)