dropFunction

Note: This is a Liquibase Pro Change Type, so you need a Liquibase Pro License Key to use it.

Drops an existing function.

Run `dropFunction`

To run this Change Type, follow these steps:

Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the update command:liquibase update

Name	Description	Required for	Supports	Since
`catalogName`	Name of the catalog		asany, db2, db2z, derby, firebird, h2, hsqldb, informix, ingres, mariadb, mysql, oracle, postgresql, sqlite, sybase
`functionName`	Name of the function	all	all
`schemaName`	Name of the schema		all

When performing rollbacks, Liquibase allows you to drop functions with or without quotes in the function name. Name Examples:

If you use double quotes like "FUNCTION1"(), the corresponding drop syntax should be DROP FUNCTION "FUNCTION1"() as well.

--liquibase formatted sql
--changeset liquibase-docs:dropFunction-example
DROP FUNCTION cat.`A String`;

--liquibase formatted sql
--changeset liquibase-docs:dropFunction-example
DROP FUNCTION cat.`A String`;