dropForeignKeyConstraint
Drops an existing foreign key.
Available attributes
baseTableCatalogName |
|
|
all |
3.0 |
baseTableName |
Name of the table containing the column constrained by the foreign key |
all |
all |
|
baseTableSchemaName |
|
|
all |
|
constraintName |
Name of the foreign key constraint to drop |
all |
all |
|
XML example
<changeSet author="liquibase-docs" id="dropForeignKeyConstraint-example">
<dropForeignKeyConstraint baseTableCatalogName="cat"
baseTableName="person"
baseTableSchemaName="public"
constraintName="fk_address_person"/>
</changeSet>
YAML example
changeSet:
id: dropForeignKeyConstraint-example
author: liquibase-docs
changes:
- dropForeignKeyConstraint:
baseTableCatalogName: cat
baseTableName: person
baseTableSchemaName: public
constraintName: fk_address_person
JSON example
{ "changeSet": { "id": "dropForeignKeyConstraint-example", "author": "liquibase-docs", "changes": [ { "dropForeignKeyConstraint": { "baseTableCatalogName": "cat", "baseTableName": "person", "baseTableSchemaName": "public", "constraintName": "fk_address_person" } }] } }
SQL example
ALTER TABLE cat.person DROP FOREIGN KEY fk_address_person;
Database support
DB2/LUW |
Supported
|
No |
DB2/z |
Supported
|
No |
Derby |
Supported
|
No |
Firebird |
Supported
|
No |
H2 |
Supported
|
No |
HyperSQL |
Supported
|
No |
INGRES |
Supported
|
No |
Informix |
Supported
|
No |
MariaDB |
Supported
|
No |
MySQL |
Supported
|
No |
Oracle |
Supported
|
No |
PostgreSQL |
Supported
|
No |
SQL Server |
Supported
|
No |
SQLite |
Not Supported |
No |
Sybase |
Supported
|
No |
Sybase Anywhere |
Supported
|
No |