dropAllForeignKeyConstraints
Drops all foreign key constraints for a table.
Run dropAllForeignKeyConstraints
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
updatecommand:liquibase update
Available attributes
Name | Description | Required for | Supports | Since |
| Name of the catalog of the table containing columns constrained by foreign keys | all | 3.0 | |
| Name of the table containing columns constrained by foreign keys | all | all | |
| Name of the schema of the table containing columns constrained by foreign keys | all |
Database support
Database | Notes | |
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
Google BigQuery | 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 |
Snowflake | Supported | No |
SQL Server | Supported | No |
SQLite | Not Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |
dropAllForeignKeyConstraints examples
databaseChangeLog:
- changeSet:
id: dropAllForeignKeyConstraints-example
author: liquibase-docs
changes:
- dropAllForeignKeyConstraints:
baseTableCatalogName: cat
baseTableName: person
baseTableSchemaName: public