Last updated: January 27, 2026
Drops an existing role in Snowflake.
Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).
Attribute | Type | Description | Required |
|---|---|---|---|
| String | Name of the role to drop | Yes |
| Boolean | Only drop if the role exists using | No |
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
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
http://www.liquibase.org/xml/ns/pro-snowflake
http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">
<!-- Basic drop -->
<changeSet id="drop-role-basic" author="examples">
<pro-snowflake:dropRole roleName="TEMPORARY_ROLE"/>
</changeSet>
<!-- Drop with IF EXISTS -->
<changeSet id="drop-role-if-exists" author="examples">
<pro-snowflake:dropRole
roleName="OLD_ROLE"
ifExists="true"/>
</changeSet>
</databaseChangeLog>{
"databaseChangeLog": [
{
"changeSet": {
"id": "drop-role-basic",
"author": "examples",
"changes": [
{
"dropRole": {
"roleName": "TEMPORARY_ROLE"
}
}
]
}
},
{
"changeSet": {
"id": "drop-role-if-exists",
"author": "examples",
"changes": [
{
"dropRole": {
"roleName": "OLD_ROLE",
"ifExists": true
}
}
]
}
}
]
}databaseChangeLog:
# Basic drop
- changeSet:
id: drop-role-basic
author: examples
changes:
- dropRole:
roleName: TEMPORARY_ROLE
# Drop with IF EXISTS
- changeSet:
id: drop-role-if-exists
author: examples
changes:
- dropRole:
roleName: OLD_ROLE
ifExists: true--liquibase formatted sql
--changeset examples:basic-drop
-- Basic drop
DROP ROLE TEMPORARY_ROLE;
--changeset examples:drop-with-if-exists
-- Drop with IF EXISTS
DROP ROLE IF EXISTS OLD_ROLE;
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
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
http://www.liquibase.org/xml/ns/pro-snowflake
http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">
<!-- Basic drop -->
<changeSet id="drop-role-basic" author="examples">
<pro-snowflake:dropRole roleName="TEMPORARY_ROLE"/>
</changeSet>
<!-- Drop with IF EXISTS -->
<changeSet id="drop-role-if-exists" author="examples">
<pro-snowflake:dropRole
roleName="OLD_ROLE"
ifExists="true"/>
</changeSet>
</databaseChangeLog>{
"databaseChangeLog": [
{
"changeSet": {
"id": "drop-role-basic",
"author": "examples",
"changes": [
{
"dropRole": {
"roleName": "TEMPORARY_ROLE"
}
}
]
}
},
{
"changeSet": {
"id": "drop-role-if-exists",
"author": "examples",
"changes": [
{
"dropRole": {
"roleName": "OLD_ROLE",
"ifExists": true
}
}
]
}
}
]
}databaseChangeLog:
# Basic drop
- changeSet:
id: drop-role-basic
author: examples
changes:
- dropRole:
roleName: TEMPORARY_ROLE
# Drop with IF EXISTS
- changeSet:
id: drop-role-if-exists
author: examples
changes:
- dropRole:
roleName: OLD_ROLE
ifExists: true--liquibase formatted sql
--changeset examples:basic-drop
-- Basic drop
DROP ROLE TEMPORARY_ROLE;
--changeset examples:drop-with-if-exists
-- Drop with IF EXISTS
DROP ROLE IF EXISTS OLD_ROLE;