alterCompositeTypeAttributes

The alterCompositeTypeAttributes change type allows you to change the attributes associated with a composite type. You can add, alter, or drop a composite type attribute.

Run alterCompositeTypeAttributes

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

Required

typeName

String

Name of the type you want to alter

Optional

Nested tags

Name

Type

Description

Requirement

addAttribute

String

Add an attribute to a composite type. This is an object that can be passed name, type, collation, and nCreate parameters.

You must choose to use addAttribute, alterAttribute, or dropAttribute.

alterAttribute

String

Change an object associated with a composite type. This is an object that can be passed name,type, collation, and onUpdate().

You must choose to use addAttribute, alterAttribute, or dropAttribute.

dropAttribute

String

Remove an attribute associated with a composite type. This is an object that can be passed name, ifExists, and onDelete().

You must choose to use addAttribute, alterAttribute, or dropAttribute.

alterCompositeTypeAttributes examples

loading