dropProcedure
Drops an existing procedure
Available attributes
catalogName |
Name of the catalog |
|
asany, db2, db2z, derby, firebird, h2, hsqldb, informix, ingres, mariadb, mysql, oracle, postgresql, sqlite, sybase |
procedureName |
Name of the stored procedure to drop |
all |
all |
schemaName |
Name of the schema |
|
all |
XML example
<changeSet author="liquibase-docs" id="dropProcedure-example">
<dropProcedure catalogName="cat"
procedureName="new_customer"
schemaName="public"/>
</changeSet>
YAML example
changeSet:
id: dropProcedure-example
author: liquibase-docs
changes:
- dropProcedure:
catalogName: cat
procedureName: new_customer
schemaName: public
JSON example
{ "changeSet": { "id": "dropProcedure-example", "author": "liquibase-docs", "changes": [ { "dropProcedure": { "catalogName": "cat", "procedureName": "new_customer", "schemaName": "public" } }] } }
SQL example
DROP PROCEDURE cat.new_customer;
Database support
DB2/LUW |
Supported
|
No |
DB2/z |
Supported
|
No |
Derby |
Supported
|
No |
Firebird |
Supported
|
No |
H2 |
Supported
|
No |
HyperSQL |
Supported
|
No |
INGRES |
Supported
|
No |
Informix |
Supported
|
No |
MariaDB |
Supported
|
No |
MySQL |
Supported
|
No |
Oracle |
Supported
|
No |
PostgreSQL |
Supported
|
No |
SQL Server |
Supported
|
No |
SQLite |
Supported
|
No |
Sybase |
Supported
|
No |
Sybase Anywhere |
Supported
|
No |