Need Liquibase® support? Liquibase Pro is now available! Try it out free.
2018 XML Announcement

Change: ‘dropPackageBody’

Drops an existing package body

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall
packageBodyNameName of the package body to dropallall
schemaNameName of the schemaall
<changeSet author="liquibase-docs"
        id="dropPackageBody-example"
        objectQuotingStrategy="LEGACY">
    <ext:dropPackageBody catalogName="cat"
            packageBodyName="A String"
            schemaName="public"/>
</changeSet>
changeSet:
  id: dropPackageBody-example
  author: liquibase-docs
  objectQuotingStrategy: LEGACY
  changes:
  - dropPackageBody:
      catalogName: cat
      packageBodyName: A String
      schemaName: public
{
  "changeSet": {
    "id": "dropPackageBody-example",
    "author": "liquibase-docs",
    "objectQuotingStrategy": "LEGACY",
    "changes": [
      {
        "dropPackageBody": {
          "catalogName": "cat",
          "packageBodyName": "A String",
          "schemaName": "public"
        }
      }]
    
  }
}

SQL Generated From Above Sample (MySQL)

DROP PACKAGE BODY cat.`A String`;

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DerbyNot SupportedNo
FirebirdNot SupportedNo
H2Not SupportedNo
HyperSQLNot SupportedNo
INGRESNot SupportedNo
InformixNot SupportedNo
MariaDBNot SupportedNo
MySQLNot SupportedNo
OracleSupportedNo
PostgreSQLNot SupportedNo
SQL ServerNot SupportedNo
SQLiteNot SupportedNo
SybaseNot SupportedNo
Sybase AnywhereNot SupportedNo

Missing, incomplete or wrong information? Please send a pull request