Drops an existing database in Snowflake with options for conditional dropping and cascade/restrict behavior.
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 database to drop | Yes |
| Boolean | Only execute if the database exists | No |
| String | Drop mode: | 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 DATABASE -->
<changeSet id="drop-database-basic" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE"/>
</changeSet>
<!-- DROP DATABASE with IF EXISTS -->
<changeSet id="drop-database-if-exists" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" ifExists="true"/>
</changeSet>
<!-- DROP DATABASE with CASCADE -->
<changeSet id="drop-database-cascade" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" dropMode="CASCADE"/>
</changeSet>
<!-- DROP DATABASE with RESTRICT -->
<changeSet id="drop-database-restrict" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" dropMode="RESTRICT"/>
</changeSet>
</databaseChangeLog><?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 DATABASE -->
<changeSet id="drop-database-basic" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE"/>
</changeSet>
<!-- DROP DATABASE with IF EXISTS -->
<changeSet id="drop-database-if-exists" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" ifExists="true"/>
</changeSet>
<!-- DROP DATABASE with CASCADE -->
<changeSet id="drop-database-cascade" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" dropMode="CASCADE"/>
</changeSet>
<!-- DROP DATABASE with RESTRICT -->
<changeSet id="drop-database-restrict" author="examples">
<pro-snowflake:dropDatabase databaseName="MY_DATABASE" dropMode="RESTRICT"/>
</changeSet>
</databaseChangeLog>