dropAttribute

The dropAttributes tag specifies information about attributes you drop with the alterCompositeTypeAttributes change type.

Available attributes

Name

Type

Description

Requirement

name

String

Name of the attribute

Required

ifExists

Boolean

Drops objects only if they exist in the database.

Optional

onDelete

String

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

Optional

dropAttribute 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
            dropAttributes:
              - dropAttribute:
                  name: attr1
                  ifExists: 'true'
                  onDelete: CASCADE
      rollback:
        - empty

dropAttribute - Liquibase