Last updated: August 12, 2026
The dropAttributes tag specifies information about attributes you drop with the alterCompositeTypeAttributes change type.
Name | Type | Description | Requirement |
| String | Name of the attribute | Required |
| Boolean | Drops objects only if they exist in the database. | Optional |
| String | Set to | Optional |
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{
"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": []
}
}
]
}<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:pro="http://www.liquibase.org/xml/ns/pro"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">
<changeSet author="itTest" id="1">
<pro:createCompositeType typeName="myType">
<pro:typeAttribute name="attr0" type="int"/>
<pro:typeAttribute name="attr1" type="int"/>
<pro:typeAttribute name="attr2" type="int"/>
</pro:createCompositeType>
</changeSet>
<changeSet author="itTest" id="2">
<pro:alterCompositeTypeAttributes typeName="myType">
<pro:dropAttribute name="attr1" ifExists="true" onDelete="CASCADE"/>
</pro:alterCompositeTypeAttributes>
<rollback/>
</changeSet>
</databaseChangeLog>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{
"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": []
}
}
]
}<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:pro="http://www.liquibase.org/xml/ns/pro"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">
<changeSet author="itTest" id="1">
<pro:createCompositeType typeName="myType">
<pro:typeAttribute name="attr0" type="int"/>
<pro:typeAttribute name="attr1" type="int"/>
<pro:typeAttribute name="attr2" type="int"/>
</pro:createCompositeType>
</changeSet>
<changeSet author="itTest" id="2">
<pro:alterCompositeTypeAttributes typeName="myType">
<pro:dropAttribute name="attr1" ifExists="true" onDelete="CASCADE"/>
</pro:alterCompositeTypeAttributes>
<rollback/>
</changeSet>
</databaseChangeLog>