createFunction

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

Creates a stored function.

Available attributes

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
dbms Specifies which database types the change must be applied to. Valid database type names are listed on the supported databases page. Separate multiple databases with commas. Specify that a change does not apply to a database type by prefixing it with !. The keywords all and none are also available. all 3.1
encoding Encoding used in the file defined in the path attribute all
functionBody all all
functionName Name of the function to drop all all
path File containing the procedure text. Either this attribute or a nested procedure text is required. all all
procedureText The SQL creating the procedure. Either this or the path attribute needs to be defined. all all
relativeTo
Changelog
File
Whether the file path relative to the changelog file rather than looked up in the search path. all
replaceIfExists If the stored procedure defined by procedureName already exits alter it instead of creating it. The default value is false. all
schemaName Name of the schema all

Database support

Database Notes Auto rollback
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
Snowflake Supported No
SQL Server Supported No
SQLite Not Supported No
Sybase Supported No
Sybase Anywhere Supported No