dropProcedure
Drops an existing procedure
Available attributes
Name | Description | Required for | Supports |
---|---|---|---|
catalogName
|
Name of the catalog |
asany, db2, db2z, derby, firebird, h2, hsqldb, informix, ingres, mariadb, mysql, oracle, postgresql, sybase | |
procedureName
|
Name of the stored procedure to drop | all | all |
schemaName
|
Name of the schema |
all |

<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"
}
}
]
}
}

DROP PROCEDURE cat.new_customer;
Database support
Database | Notes | Auto Rollback |
---|---|---|
DB2/LUW | Supported | Yes |
DB2/z | Supported | Yes |
Derby | Supported | Yes |
Firebird | Supported | Yes |
H2 | Supported | Yes |
HyperSQL | Supported | Yes |
INGRES | Supported | Yes |
Informix | Supported | Yes |
MariaDB | Supported | Yes |
MySQL | Supported | Yes |
Oracle | Supported | Yes |
PostgreSQL | Supported | Yes |
Snowflake | Supported | Yes |
SQL Server | Supported | Yes |
SQLite | Not Supported | No |
Sybase | Supported | Yes |
Sybase Anywhere | Supported | Yes |