createPackage

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

Creates a package.

Available attributes

Name Description Required for Supports Since
catalogName

Name of the catalog

 all
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
packageName Name of the package to drop all all
packageText 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
relativeToChange
log-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. all
schemaName

Name of the schema

 all 
<changeSet  author="liquibase-docs"  id="createPackage-example">
    <pro:createPackage  catalogName="cat"
            dbms="h2, !oracle, mysql"
            encoding="UTF-8"
            packageName="A String"
            path="com/example/my-logic.sql"
            relativeToChangelogFile="true"
            replaceIfExists="false"
            schemaName="public">A String</pro:createPackage>
</changeSet>
changeSet:
  id:  createPackage-example
  author:  liquibase-docs
  changes:
  -  createPackage:
      catalogName:  cat
      dbms:  h2, !oracle, mysql
      encoding:  UTF-8
      packageName:  A String
      packageText:  A String
      path:  com/example/my-logic.sql
      relativeToChangelogFile:  true
      replaceIfExists:  false
      schemaName:  public
{
  "changeSet":  {
    "id":  "createPackage-example",
    "author":  "liquibase-docs",  "changes":  [{
      "createPackage":  {
        "catalogName":  "cat",
        "dbms":  "h2, !oracle, mysql",
        "encoding":  "UTF-8",
        "packageName":  "A String",
        "packageText":  "A String",
        "path":  "com/example/my-logic.sql",
        "relativeToChangelogFile":  true,
        "replaceIfExists":  false,
        "schemaName":  "public"
      }
    }]
  }
}

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 Not Supported No
SQL Server Supported Yes
SQLite Supported Yes
Sybase Supported Yes
Sybase Anywhere Supported Yes