Change: ‘dropAllForeignKeyConstraints’

Drops all foreign key constraints for a table

Available Attributes

NameDescriptionRequired ForSupportsSince
baseTableCatalogNameName of the table containing columns constrained by foreign keysall3.0
baseTableNameallall
baseTableSchemaNameall
<changeSet author="liquibase-docs" id="dropAllForeignKeyConstraints-example">
    <dropAllForeignKeyConstraints baseTableCatalogName="cat"
            baseTableName="person"
            baseTableSchemaName="public"/>
</changeSet>
changeSet:
  id: dropAllForeignKeyConstraints-example
  author: liquibase-docs
  changes:
  - dropAllForeignKeyConstraints:
      baseTableCatalogName: cat
      baseTableName: person
      baseTableSchemaName: public
{
  "changeSet": {
    "id": "dropAllForeignKeyConstraints-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "dropAllForeignKeyConstraints": {
          "baseTableCatalogName": "cat",
          "baseTableName": "person",
          "baseTableSchemaName": "public"
        }
      }]
    
  }
}

Database Support

DatabaseNotesAuto Rollback
DB2/LUWSupportedNo
DB2/zSupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
INGRESSupportedNo
InformixSupportedNo
MariaDBSupportedNo
MySQLSupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteSupportedNo
SybaseSupportedNo
Sybase AnywhereSupportedNo