Learn how to govern Snowflake roles, shares, and data movement without slowing delivery. Join our live webinar on controlling drift, permissions, and audit readiness.
Last updated: September 2, 2025
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:
- empty