alterAttribute
The alterAttributes tag specifies information about attributes you modify with the alterCompositeTypeAttributes change type.
Available attributes
Name | Type | Description | Requirement |
| String | Name of the composite type attribute to be created | Required |
| String | Name of the type the attribute will be associated with | Required |
String | Name of an existing collation to be associated with a column of a composite type, or with a range type | Optional | |
| String | Set to | 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