alterAttribute

The alterAttributes tag specifies information about attributes you modify with the alterCompositeTypeAttributes change type.

Available attributes

Name

Type

Description

Requirement

name

String

Name of the composite type attribute to be created

Required

newType

String

Name of the type the attribute will be associated with

Required

collation

String

Name of an existing collation to be associated with a column of a composite type, or with a range type

Optional

onUpdate

String

Set to CASCADE or RESTRICT. CASCADE automatically updates objects that depend on the type. RESTRICT does not update the type if any objects depend on it. Default: RESTRICT.

Optional

alterAttribute examples

databaseChangeLog:
  - changeSet:
      id: 1
      author: itTest
      changes:
        - createCompositeType:
            typeName: myType
            typeAttributes:
              - typeAttribute:
                  name: attr0
                  type: int
              - typeAttribute:
                  name: attr1
                  type: int
              - typeAttribute:
                  name: attr2
                  type: int
  - changeSet:
      id: 2
      author: itTest
      changes:
        - alterCompositeTypeAttributes:
            typeName: myType
            alterAttributes:
              - alterAttribute:
                  name: attr0
                  newType: text
                  collation: en_US
                  onUpdate: RESTRICT
      rollback:
        - empty