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: ‘dropFunction’

Drops an existing function

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogasany, db2, db2z, derby, firebird, h2, hsqldb, informix, ingres, mariadb, mysql, oracle, postgresql, sqlite, sybase
functionNameName of the function to dropallall
schemaNameName of the schemaall
<changeSet author="liquibase-docs" id="dropFunction-example">
    <pro:dropFunction catalogName="cat"
            functionName="A String"
            schemaName="public"/>
</changeSet>
changeSet:
  id: dropFunction-example
  author: liquibase-docs
  changes:
  - dropFunction:
      catalogName: cat
      functionName: A String
      schemaName: public
{
  "changeSet": {
    "id": "dropFunction-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "dropFunction": {
          "catalogName": "cat",
          "functionName": "A String",
          "schemaName": "public"
        }
      }]
    
  }
}

SQL Generated From Above Sample (MySQL)

DROP FUNCTION cat.`A String`;

Database Support

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