org.h2.command.ddl
Class AlterTableAddConstraint

java.lang.Object
  extended by org.h2.command.Prepared
      extended by org.h2.command.ddl.DefineCommand
          extended by org.h2.command.ddl.SchemaCommand
              extended by org.h2.command.ddl.AlterTableAddConstraint

public class AlterTableAddConstraint
extends SchemaCommand

This class represents the statement ALTER TABLE ADD CONSTRAINT


Field Summary
static int CHECK
          The type of a ALTER TABLE ADD CHECK statement.
static int PRIMARY_KEY
          The type of a ALTER TABLE ADD PRIMARY KEY statement.
static int REFERENTIAL
          The type of a ALTER TABLE ADD FOREIGN KEY statement.
static int UNIQUE
          The type of a ALTER TABLE ADD UNIQUE statement.
 
Fields inherited from class org.h2.command.Prepared
headPos, parameters, prepareAlways, session, sqlStatement
 
Constructor Summary
AlterTableAddConstraint(Session session, Schema schema, boolean ifNotExists)
           
 
Method Summary
 IndexColumn[] getIndexColumns()
           
 int getType()
           
 void setCheckExisting(boolean b)
           
 void setCheckExpression(Expression expression)
           
 void setComment(java.lang.String comment)
           
 void setConstraintName(java.lang.String constraintName)
           
 void setDeleteAction(int action)
           
 void setIndex(Index index)
           
 void setIndexColumns(IndexColumn[] indexColumns)
           
 void setPrimaryKeyHash(boolean b)
           
 void setRefIndex(Index refIndex)
           
 void setRefIndexColumns(IndexColumn[] indexColumns)
           
 void setRefTableName(Schema refSchema, java.lang.String ref)
          Set the referenced table.
 void setTableName(java.lang.String tableName)
           
 void setType(int type)
           
 void setUpdateAction(int action)
           
 int tryUpdate()
          Try to execute the statement.
 int update()
          Execute the statement.
 
Methods inherited from class org.h2.command.ddl.SchemaCommand
getSchema
 
Methods inherited from class org.h2.command.ddl.DefineCommand
isReadOnly, isTransactional, queryMeta
 
Methods inherited from class org.h2.command.Prepared
checkCanceled, checkParameters, getCurrentObjectId, getCurrentRowNumber, getObjectId, getParameters, getPlanSQL, getSQL, getSQL, getSQL, isQuery, needRecompile, prepare, query, setCommand, setCurrentRowNumber, setHeadPos, setObjectId, setParameterList, setPrepareAlways, setRow, setSession, setSQL, toString
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

CHECK

public static final int CHECK
The type of a ALTER TABLE ADD CHECK statement.

See Also:
Constant Field Values

UNIQUE

public static final int UNIQUE
The type of a ALTER TABLE ADD UNIQUE statement.

See Also:
Constant Field Values

REFERENTIAL

public static final int REFERENTIAL
The type of a ALTER TABLE ADD FOREIGN KEY statement.

See Also:
Constant Field Values

PRIMARY_KEY

public static final int PRIMARY_KEY
The type of a ALTER TABLE ADD PRIMARY KEY statement.

See Also:
Constant Field Values
Constructor Detail

AlterTableAddConstraint

public AlterTableAddConstraint(Session session,
                               Schema schema,
                               boolean ifNotExists)
Method Detail

update

public int update()
           throws java.sql.SQLException
Description copied from class: Prepared
Execute the statement.

Overrides:
update in class Prepared
Returns:
the update count
Throws:
java.sql.SQLException - if it is a query

tryUpdate

public int tryUpdate()
              throws java.sql.SQLException
Try to execute the statement.

Returns:
the update count
Throws:
java.sql.SQLException

setDeleteAction

public void setDeleteAction(int action)

setUpdateAction

public void setUpdateAction(int action)

setConstraintName

public void setConstraintName(java.lang.String constraintName)

setType

public void setType(int type)

getType

public int getType()

setCheckExpression

public void setCheckExpression(Expression expression)

setTableName

public void setTableName(java.lang.String tableName)

setIndexColumns

public void setIndexColumns(IndexColumn[] indexColumns)

getIndexColumns

public IndexColumn[] getIndexColumns()

setRefTableName

public void setRefTableName(Schema refSchema,
                            java.lang.String ref)
Set the referenced table.

Parameters:
refSchema - the schema
ref - the table name

setRefIndexColumns

public void setRefIndexColumns(IndexColumn[] indexColumns)

setIndex

public void setIndex(Index index)

setRefIndex

public void setRefIndex(Index refIndex)

setComment

public void setComment(java.lang.String comment)

setCheckExisting

public void setCheckExisting(boolean b)

setPrimaryKeyHash

public void setPrimaryKeyHash(boolean b)