renameCompositeType

The renameCompositeType Change Type allows you to change the name of a user-defined composite type. It allows you to align with naming standards, clarify a purpose, and refactor your schema structure. When you rename a composite type, all dependent objects, such as tables that refer to the composite type, must be updated manually.

Run renameCompositeType

To run this Change Type, follow these steps:

  1. Add the Change Type to your changeset, as shown in the examples on this page.

  2. Specify any required attributes. Use the table on this page to see which ones your database requires.

  3. Deploy your changeset by running the update command:liquibase update

Available attributes

Name

Type

Description

Requirement

catalogName

String

Name of the catalog.

Optional

schemaName

String

Name of the schema that contains the composite type you want to alter.

Optional

oldTypeName

String

Name of the composite type that you no longer want to use.

Required

newTypeName

String

Name of the new type that you want to use.

Required

renameCompositeType examples

loading

renameCompositeType - Liquibase