Liquibase® version 3.8.5 is now available! Get it for free.
2018 XML Announcement
News All Previous Posts >>

Subscribe for email updates

- and/or -

Change: ‘dropProcedure’

Drops an existing procedure

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogasany, db2, db2z, derby, firebird, h2, hsqldb, informix, ingres, mariadb, mysql, oracle, postgresql, sqlite, sybase
procedureNameName of the stored procedure to dropallall
schemaNameName of the schemaall
<changeSet author="liquibase-docs" id="dropProcedure-example">
    <dropProcedure catalogName="cat"
            procedureName="new_customer"
            schemaName="public"/>
</changeSet>
changeSet:
  id: dropProcedure-example
  author: liquibase-docs
  changes:
  - dropProcedure:
      catalogName: cat
      procedureName: new_customer
      schemaName: public
{
  "changeSet": {
    "id": "dropProcedure-example",
    "author": "liquibase-docs",
    "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