Top Description Fields Constructors Methods
org.h2.command.ddl

public Class CreateTable

extends CommandWithColumns
Class Inheritance
Imports
java.util.ArrayList, .HashSet, org.h2.api.ErrorCode, org.h2.command.CommandInterface, org.h2.command.dml.Insert, org.h2.command.query.Query, org.h2.engine.Database, .DbObject, .SessionLocal, org.h2.expression.Expression, org.h2.message.DbException, org.h2.schema.Schema, .Sequence, org.h2.table.Column, .Table, org.h2.value.Value
This class represents the statement CREATE TABLE

Field Summary

Modifier and TypeField and Description
private Query
asQuery

private String
comment

private final CreateTableData
data

private boolean
ifNotExists

private boolean
onCommitDrop

private boolean
onCommitTruncate

private boolean
withNoData

Constructor Summary

AccessConstructor and Description
public
CreateTable(SessionLocal session, Schema schema)

Method Summary

Modifier and TypeMethod and Description
public void
addColumn(Column
the column to add
column)

Implements abstract org.h2.command.ddl.CommandWithColumns.addColumn.

Add a column to this table.

private void
generateColumnsFromQuery()

public ArrayList<Column>
getColumns()

public int
getType()

Implements abstract org.h2.command.Prepared.getType.

Get the command type as defined in CommandInterface

pack-priv void
insertAsData(Table table)

This is called from REFRESH MATERIALIZED VIEW

private void
insertAsData(boolean isSessionTemporary, Database db, Table table)

Insert data for the CREATE TABLE ..

public void
setComment(String comment)

public void
setGlobalTemporary(boolean globalTemporary)

public void
setIfNotExists(boolean ifNotExists)

public void
setOnCommitDrop()

This temporary table is dropped on commit.

public void
setOnCommitTruncate()

This temporary table is truncated on commit.

public void
setPersistData(boolean persistData)

public void
setPersistIndexes(boolean persistIndexes)

public void
setQuery(Query query)

public void
setTableEngine(String tableEngine)

public void
setTableEngineParams(ArrayList<String> tableEngineParams)

public void
setTableName(String tableName)

public void
setTemporary(boolean temporary)

public void
setWithNoData(boolean withNoData)

public long
update()

Overrides org.h2.command.Prepared.update.

Execute the statement.

Inherited from org.h2.command.ddl.CommandWithColumns:
addConstraintCommandchangePrimaryKeysToNotNullcreateConstraintsgenerateSequencesgetPrimaryKey

Field Detail

asQueryback to summary
private Query asQuery
commentback to summary
private String comment
databack to summary
private final CreateTableData data
ifNotExistsback to summary
private boolean ifNotExists
onCommitDropback to summary
private boolean onCommitDrop
onCommitTruncateback to summary
private boolean onCommitTruncate
withNoDataback to summary
private boolean withNoData

Constructor Detail

CreateTableback to summary
public CreateTable(SessionLocal session, Schema schema)

Method Detail

addColumnback to summary
public void addColumn(Column column)

Implements abstract org.h2.command.ddl.CommandWithColumns.addColumn.

Doc from org.h2.command.ddl.CommandWithColumns.addColumn.

Add a column to this table.

Parameters
column:Column

the column to add

Annotations
@Override
generateColumnsFromQueryback to summary
private void generateColumnsFromQuery()
getColumnsback to summary
public ArrayList<Column> getColumns()
getTypeback to summary
public int getType()

Implements abstract org.h2.command.Prepared.getType.

Doc from org.h2.command.Prepared.getType.

Get the command type as defined in CommandInterface

Returns:int

the statement type

Annotations
@Override
insertAsDataback to summary
pack-priv void insertAsData(Table table)

This is called from REFRESH MATERIALIZED VIEW

insertAsDataback to summary
private void insertAsData(boolean isSessionTemporary, Database db, Table table)

Insert data for the CREATE TABLE .. AS

setCommentback to summary
public void setComment(String comment)
setGlobalTemporaryback to summary
public void setGlobalTemporary(boolean globalTemporary)
setIfNotExistsback to summary
public void setIfNotExists(boolean ifNotExists)
setOnCommitDropback to summary
public void setOnCommitDrop()

This temporary table is dropped on commit.

setOnCommitTruncateback to summary
public void setOnCommitTruncate()

This temporary table is truncated on commit.

setPersistDataback to summary
public void setPersistData(boolean persistData)
setPersistIndexesback to summary
public void setPersistIndexes(boolean persistIndexes)
setQueryback to summary
public void setQuery(Query query)
setTableEngineback to summary
public void setTableEngine(String tableEngine)
setTableEngineParamsback to summary
public void setTableEngineParams(ArrayList<String> tableEngineParams)
setTableNameback to summary
public void setTableName(String tableName)
setTemporaryback to summary
public void setTemporary(boolean temporary)
setWithNoDataback to summary
public void setWithNoData(boolean withNoData)
updateback to summary
public long update()

Overrides org.h2.command.Prepared.update.

Doc from org.h2.command.Prepared.update.

Execute the statement.

Returns:long

the update count

Annotations
@Override