Liquibase 4.26.0 · liquibase.statement.core.AddForeignKeyConstraintStatement

Modifier and Type	Field and Description
private final ColumnConfig[]	baseColumns
private final String	baseTableCatalogName
private final String	baseTableName
private final String	baseTableSchemaName
private final String	constraintName
private boolean	deferrable
private boolean	initiallyDeferred
private String	onDelete
private String	onUpdate
private final ColumnConfig[]	referencedColumns
private final String	referencedTableCatalogName
private final String	referencedTableName
private final String	referencedTableSchemaName
private boolean	shouldValidate

Access	Constructor and Description
public	AddForeignKeyConstraintStatement(String constraintName, String baseTableCatalogName, String baseTableSchemaName, String baseTableName, ColumnConfig[] baseColumns, String referencedTableCatalogName, String referencedTableSchemaName, String referencedTableName, ColumnConfig[] referencedColumns)

Method Summary

Modifier and Type	Method and Description
public String	getBaseColumnNames()
public ColumnConfig[]	getBaseColumns()
public String	getBaseTableCatalogName()
public String	getBaseTableName()
public String	getBaseTableSchemaName()
public String	getConstraintName()
public String	getOnDelete()
public String	getOnUpdate()
public String	getReferencedColumnNames()
public ColumnConfig[]	getReferencedColumns()
public String	getReferencedTableCatalogName()
public String	getReferencedTableName()
public String	getReferencedTableSchemaName()
public boolean	isDeferrable()
public boolean	isInitiallyDeferred()
public AddForeignKeyConstraintStatement	setDeferrable(boolean deferrable)
public AddForeignKeyConstraintStatement	setInitiallyDeferred(boolean initiallyDeferred)
public AddForeignKeyConstraintStatement	setOnDelete(String deleteRule)
public AddForeignKeyConstraintStatement	setOnUpdate(String updateRule)
public AddForeignKeyConstraintStatement	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 foreign keys - only new data would be checked to see if it complies with the constraint logic. The default state for foreign keys is to have 'ENABLE VALIDATE' set. shouldValidate)
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 foreign key constraint on a column in a table should be checked if it refers to a valid row or not.

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

Field Detail

baseColumns	back to summary
private final ColumnConfig[] baseColumns

baseTableCatalogName	back to summary
private final String baseTableCatalogName

baseTableName	back to summary
private final String baseTableName

baseTableSchemaName	back to summary
private final String baseTableSchemaName

constraintName	back to summary
private final String constraintName

deferrable	back to summary
private boolean deferrable

initiallyDeferred	back to summary
private boolean initiallyDeferred

onDelete	back to summary
private String onDelete

onUpdate	back to summary
private String onUpdate

referencedColumns	back to summary
private final ColumnConfig[] referencedColumns

referencedTableCatalogName	back to summary
private final String referencedTableCatalogName

referencedTableName	back to summary
private final String referencedTableName

referencedTableSchemaName	back to summary
private final String referencedTableSchemaName

shouldValidate	back to summary
private boolean shouldValidate

Constructor Detail

AddForeignKeyConstraintStatement	back to summary
public AddForeignKeyConstraintStatement(String constraintName, String baseTableCatalogName, String baseTableSchemaName, String baseTableName, ColumnConfig[] baseColumns, String referencedTableCatalogName, String referencedTableSchemaName, String referencedTableName, ColumnConfig[] referencedColumns)

Method Detail

getBaseColumnNames	back to summary
public String getBaseColumnNames()

getBaseColumns	back to summary
public ColumnConfig[] getBaseColumns()

getBaseTableCatalogName	back to summary
public String getBaseTableCatalogName()

getBaseTableName	back to summary
public String getBaseTableName()

getBaseTableSchemaName	back to summary
public String getBaseTableSchemaName()

getConstraintName	back to summary
public String getConstraintName()

getOnDelete	back to summary
public String getOnDelete()

getOnUpdate	back to summary
public String getOnUpdate()

getReferencedColumnNames	back to summary
public String getReferencedColumnNames()

getReferencedColumns	back to summary
public ColumnConfig[] getReferencedColumns()

getReferencedTableCatalogName	back to summary
public String getReferencedTableCatalogName()

getReferencedTableName	back to summary
public String getReferencedTableName()

getReferencedTableSchemaName	back to summary
public String getReferencedTableSchemaName()

isDeferrable	back to summary
public boolean isDeferrable()

isInitiallyDeferred	back to summary
public boolean isInitiallyDeferred()

setDeferrable	back to summary
public AddForeignKeyConstraintStatement setDeferrable(boolean deferrable)

setInitiallyDeferred	back to summary
public AddForeignKeyConstraintStatement setInitiallyDeferred(boolean initiallyDeferred)

setOnDelete	back to summary
public AddForeignKeyConstraintStatement setOnDelete(String deleteRule)

setOnUpdate	back to summary
public AddForeignKeyConstraintStatement setOnUpdate(String updateRule)

setShouldValidate	back to summary
public AddForeignKeyConstraintStatement 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 foreign keys - only new data would be checked to see if it complies with the constraint logic. The default state for foreign keys is to have 'ENABLE VALIDATE' set.

setShouldValidate

back to summary

public AddForeignKeyConstraintStatement 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 foreign keys - only new data would be checked to see if it complies with the constraint logic. The default state for foreign keys is to have 'ENABLE VALIDATE' set.

shouldValidate	back to summary
public boolean shouldValidate() In Oracle PL/SQL, the VALIDATE keyword defines whether a foreign key constraint on a column in a table should be checked if it refers to a valid row 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 foreign key constraint on a column in a table should be checked if it refers to a valid row or not.

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

public Class AddForeignKeyConstraintStatement

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail