Package liquibase.statement.core

Class AddUniqueConstraintStatement

java.lang.Object

liquibase.statement.AbstractSqlStatement

liquibase.statement.core.AddUniqueConstraintStatement

All Implemented Interfaces:

SqlStatement

public class AddUniqueConstraintStatement
extends AbstractSqlStatement

Field Summary

Fields inherited from interface liquibase.statement.SqlStatement

EMPTY_SQL_STATEMENT

Constructor Summary

Constructors

Constructor	Description
AddUniqueConstraintStatement(String catalogName, String schemaName, String tableName, ColumnConfig[] columns, String constraintName)

Method Summary

Modifier and Type	Method	Description
String	getCatalogName()
String	getColumnNames()
String	getSchemaName()
String	getTableName()
AddUniqueConstraintStatement	setClustered(boolean clustered)
AddUniqueConstraintStatement	setDeferrable(boolean deferrable)
AddUniqueConstraintStatement	setDisabled(boolean disabled)
AddUniqueConstraintStatement	setInitiallyDeferred(boolean initiallyDeferred)
AddUniqueConstraintStatement	setShouldValidate(boolean shouldValidate)
AddUniqueConstraintStatement	setTablespace(String tablespace)
boolean	shouldValidate()	In Oracle PL/SQL, the VALIDATE keyword defines whether a newly added unique constraint on a column in a table should cause existing rows to be checked to see if they satisfy the uniqueness constraint or not.

Methods inherited from class liquibase.statement.AbstractSqlStatement

continueOnError, setContinueOnError, skipOnUnsupported

Methods inherited from class java.lang.Object

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

Constructor Details

AddUniqueConstraintStatement

public AddUniqueConstraintStatement(String catalogName,
 String schemaName,
 String tableName,
 ColumnConfig[] columns,
 String constraintName)

Method Details

getColumnNames

public String getColumnNames()

setTablespace

public AddUniqueConstraintStatement setTablespace(String tablespace)

setDeferrable

public AddUniqueConstraintStatement setDeferrable(boolean deferrable)

setInitiallyDeferred

public AddUniqueConstraintStatement setInitiallyDeferred(boolean initiallyDeferred)

setDisabled

public AddUniqueConstraintStatement setDisabled(boolean disabled)

setClustered

public AddUniqueConstraintStatement setClustered(boolean clustered)

shouldValidate

public boolean shouldValidate()

In Oracle PL/SQL, the VALIDATE keyword defines whether a newly added unique constraint on a column in a table should cause existing rows to be checked to see if they satisfy the uniqueness constraint or not.

Returns:

true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE.

setShouldValidate

public AddUniqueConstraintStatement setShouldValidate(boolean shouldValidate)

Parameters:

shouldValidate - - if shouldValidate is set to FALSE then the constraint will be created with the 'ENABLE NOVALIDATE' mode. This means the constraint would be created, but that no check will be done to ensure old data has valid constraints - only new data would be checked to see if it complies with the constraint logic. The default state for unique constraints is to have 'ENABLE VALIDATE' set.

getTableName

public String getTableName()

getSchemaName

public String getSchemaName()

getCatalogName

public String getCatalogName()