Class CreateIndex

java.lang.Object

org.h2.command.Prepared

org.h2.command.ddl.DefineCommand

org.h2.command.ddl.SchemaCommand

org.h2.command.ddl.CreateIndex

public class CreateIndex
extends SchemaCommand

This class represents the statement CREATE INDEX

Field Summary

Fields

Modifier and Type	Field	Description
private String	comment
private boolean	hash
private boolean	ifNotExists
private boolean	ifTableExists
private IndexColumn[]	indexColumns
private String	indexName
private boolean	primaryKey
private boolean	spatial
private String	tableName
private int	uniqueColumnCount

Fields inherited from class DefineCommand

transactional

Fields inherited from class Prepared

create, parameters, prepareAlways, session, sqlStatement, sqlTokens

Constructor Summary

Constructors

Constructor	Description
CreateIndex(SessionLocal session, Schema schema)

Method Summary

Modifier and Type	Method	Description
int	getType()	Get the command type as defined in CommandInterface
void	setComment(String comment)
void	setHash(boolean b)
void	setIfNotExists(boolean ifNotExists)
void	setIfTableExists(boolean b)
void	setIndexColumns(IndexColumn[] columns)
void	setIndexName(String indexName)
void	setPrimaryKey(boolean b)
void	setSpatial(boolean b)
void	setTableName(String tableName)
void	setUniqueColumnCount(int uniqueColumnCount)
long	update()	Execute the statement.

Methods inherited from class SchemaCommand

getSchema

Methods inherited from class DefineCommand

isReadOnly, isTransactional, queryMeta, setTransactional

Methods inherited from class Prepared

checkCanceled, checkParameters, collectDependencies, getCteCleanups, getCurrentRowNumber, getObjectId, getParameters, getPersistedObjectId, getPlanSQL, getSession, getSimpleSQL, getSQL, getSQLTokens, isCacheable, isQuery, needRecompile, prepare, query, setCommand, setCteCleanups, setCurrentRowNumber, setParameterList, setPersistedObjectId, setPrepareAlways, setRow, setSession, setSQL, toString

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

tableName

private String tableName

indexName

private String indexName

indexColumns

private IndexColumn[] indexColumns

uniqueColumnCount

private int uniqueColumnCount

primaryKey

private boolean primaryKey

hash

private boolean hash

spatial

private boolean spatial

ifTableExists

private boolean ifTableExists

ifNotExists

private boolean ifNotExists

comment

private String comment

Constructor Details

CreateIndex

public CreateIndex(SessionLocal session,
 Schema schema)

Method Details

setIfTableExists

public void setIfTableExists(boolean b)

setIfNotExists

public void setIfNotExists(boolean ifNotExists)

setTableName

public void setTableName(String tableName)

setIndexName

public void setIndexName(String indexName)

setIndexColumns

public void setIndexColumns(IndexColumn[] columns)

update

public long update()

Description copied from class: Prepared

Execute the statement.

Overrides:

update in class Prepared

Returns:

the update count

setPrimaryKey

public void setPrimaryKey(boolean b)

setUniqueColumnCount

public void setUniqueColumnCount(int uniqueColumnCount)

setHash

public void setHash(boolean b)

setSpatial

public void setSpatial(boolean b)

setComment

public void setComment(String comment)

getType

public int getType()

Description copied from class: Prepared

Get the command type as defined in CommandInterface

Specified by:

getType in class Prepared

Returns:

the statement type