Copy to clipboard

dropForeignKeyConstraint

Drops an existing foreign key.

To run this Change Type, follow these steps:

Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the update command:liquibase update

Name	Description	Required for	Supports	Since
`baseTableCatalogName`	Name of the catalog of the base table		all	3.0
`baseTableName`	Name of the table containing the column constrained by the foreign key	all	all
`baseTableSchemaName`	Name of the schema of the base table		all
`constraintName`	Name of the constraint (foreign key) to drop	all	all

--liquibase formatted sql
--changeset liquibase-docs:dropForeignKeyConstraint-example
ALTER TABLE cat.person
DROP FOREIGN KEY fk_address_person;

--liquibase formatted sql
--changeset liquibase-docs:dropForeignKeyConstraint-example
ALTER TABLE cat.person
DROP FOREIGN KEY fk_address_person;