Liquibase® version 3.8.2 is now available! Get it for free.
2018 XML Announcement
News 5 Ways to Fix a Bad Database Change in Liquibase
04 Dec 2019

- and/or -

All Previous Posts >>

Change: ‘dropProcedure’

Drops an existing procedure

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall
procedureNameName of the stored procedure to dropallall
schemaNameName of the schemaall
<changeSet author="liquibase-docs"
        id="dropProcedure-example"
        objectQuotingStrategy="LEGACY">
    <dropProcedure catalogName="cat"
            procedureName="new_customer"
            schemaName="public"/>
</changeSet>
changeSet:
  id: dropProcedure-example
  author: liquibase-docs
  objectQuotingStrategy: LEGACY
  changes:
  - dropProcedure:
      catalogName: cat
      procedureName: new_customer
      schemaName: public
{
  "changeSet": {
    "id": "dropProcedure-example",
    "author": "liquibase-docs",
    "objectQuotingStrategy": "LEGACY",
    "changes": [
      {
        "dropProcedure": {
          "catalogName": "cat",
          "procedureName": "new_customer",
          "schemaName": "public"
        }
      }]
    
  }
}

SQL Generated From Above Sample (MySQL)

DROP PROCEDURE cat.new_customer;

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DB2SupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
INGRESSupportedNo
InformixSupportedNo
MariaDBSupportedNo
MySQLSupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteSupportedNo
SybaseSupportedNo
Sybase AnywhereSupportedNo