Liquibase 4.26.0 · liquibase.statement.core.AddUniqueConstraintStatement

Field Summary

Modifier and Type	Field and Description
private final String	catalogName
private boolean	clustered
private final ColumnConfig[]	columns
private final String	constraintName
private boolean	deferrable
private boolean	disabled
private String	forIndexCatalogName
private String	forIndexName
private String	forIndexSchemaName
private boolean	initiallyDeferred
private final String	schemaName
private boolean	shouldValidate
private final String	tableName
private String	tablespace

Constructor Summary

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

Method Summary

Modifier and Type	Method and Description
public String	getCatalogName()
public String	getColumnNames()
public ColumnConfig[]	getColumns()
public String	getConstraintName()
public String	getForIndexCatalogName()
public String	getForIndexName()
public String	getForIndexSchemaName()
public String	getSchemaName()
public String	getTableName()
public String	getTablespace()
public boolean	isClustered()
public boolean	isDeferrable()
public boolean	isDisabled()
public boolean	isInitiallyDeferred()
public AddUniqueConstraintStatement	setClustered(boolean clustered)
public AddUniqueConstraintStatement	setDeferrable(boolean deferrable)
public AddUniqueConstraintStatement	setDisabled(boolean disabled)
public void	setForIndexCatalogName(String forIndexCatalogName)
public void	setForIndexName(String forIndexName)
public void	setForIndexSchemaName(String forIndexSchemaName)
public AddUniqueConstraintStatement	setInitiallyDeferred(boolean initiallyDeferred)
public AddUniqueConstraintStatement	setShouldValidate(boolean - 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. shouldValidate)
public AddUniqueConstraintStatement	setTablespace(String tablespace)
public boolean	Returns: true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE. 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.

Inherited from liquibase.statement.AbstractSqlStatement:: continueOnError setContinueOnError skipOnUnsupported

Field Detail

catalogName	back to summary
private final String catalogName

clustered	back to summary
private boolean clustered

columns	back to summary
private final ColumnConfig[] columns

constraintName	back to summary
private final String constraintName

deferrable	back to summary
private boolean deferrable

disabled	back to summary
private boolean disabled

forIndexCatalogName	back to summary
private String forIndexCatalogName

forIndexName	back to summary
private String forIndexName

forIndexSchemaName	back to summary
private String forIndexSchemaName

initiallyDeferred	back to summary
private boolean initiallyDeferred

schemaName	back to summary
private final String schemaName

shouldValidate	back to summary
private boolean shouldValidate

tableName	back to summary
private final String tableName

tablespace	back to summary
private String tablespace

Constructor Detail

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

Method Detail

getCatalogName	back to summary
public String getCatalogName()

getColumnNames	back to summary
public String getColumnNames()

getColumns	back to summary
public ColumnConfig[] getColumns()

getConstraintName	back to summary
public String getConstraintName()

getForIndexCatalogName	back to summary
public String getForIndexCatalogName()

getForIndexName	back to summary
public String getForIndexName()

getForIndexSchemaName	back to summary
public String getForIndexSchemaName()

getSchemaName	back to summary
public String getSchemaName()

getTableName	back to summary
public String getTableName()

getTablespace	back to summary
public String getTablespace()

isClustered	back to summary
public boolean isClustered()

isDeferrable	back to summary
public boolean isDeferrable()

isDisabled	back to summary
public boolean isDisabled()

isInitiallyDeferred	back to summary
public boolean isInitiallyDeferred()

setClustered	back to summary
public AddUniqueConstraintStatement setClustered(boolean clustered)

setDeferrable	back to summary
public AddUniqueConstraintStatement setDeferrable(boolean deferrable)

setDisabled	back to summary
public AddUniqueConstraintStatement setDisabled(boolean disabled)

setForIndexCatalogName	back to summary
public void setForIndexCatalogName(String forIndexCatalogName)

setForIndexName	back to summary
public void setForIndexName(String forIndexName)

setForIndexSchemaName	back to summary
public void setForIndexSchemaName(String forIndexSchemaName)

setInitiallyDeferred	back to summary
public AddUniqueConstraintStatement setInitiallyDeferred(boolean initiallyDeferred)

setShouldValidate	back to summary
public AddUniqueConstraintStatement setShouldValidate(boolean shouldValidate) Parameters shouldValidate:boolean - 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.

setShouldValidate

back to summary

public AddUniqueConstraintStatement setShouldValidate(boolean shouldValidate)

Parameters

shouldValidate:boolean: - 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.

setTablespace	back to summary
public AddUniqueConstraintStatement setTablespace(String tablespace)

shouldValidate	back to summary
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:boolean true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE.

shouldValidate

back to summary

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:boolean: true if ENABLE VALIDATE (this is the default), or false if ENABLE NOVALIDATE.

public Class AddUniqueConstraintStatement

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail