Snowflake dropView

Last updated: March 26, 2026

Last updated: March 25, 2026

Drops an existing Snowflake view.

Known limitations:

This change type does not support automatic rollback.
Snowflake snapshots created with Liquibase Secure 5.1 are incompatible with earlier versions due to enhanced object type detection for TABLES and VIEWS. Regenerate all snapshots with 5.1 after upgrading to avoid false differences in diff and diff-changelog operations.
The Liquibase dropView change type is not compatible for Snowflake users in Liquibase Secure 5.1 using YAML or JSON change type formats. This does not affect XML change types at all. If you’re connecting to a Snowflake database, Liquibase automatically detects you are using the Snowflake dropView change type and breaks backwards compatibility with the Liquibase dropView change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the view	No
`schemaName`	String	Name of the schema containing the view	No
`viewName`	String	Name of the view to drop	Yes
`ifExists`	Boolean	If true, only drops the view if it exists using `IF EXISTS`	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">

    <!-- Drop view with IF EXISTS -->
    <changeSet id="drop-view" author="examples">
        <pro-snowflake:dropView
            viewName="MY_VIEW"
            ifExists="true"/>
    </changeSet>

    <!-- Drop view with schema qualification -->
    <changeSet id="drop-view-qualified" author="examples">
        <pro-snowflake:dropView
            schemaName="ANALYTICS"
            viewName="SALES_SUMMARY"
            ifExists="true"/>
    </changeSet>

    <!-- Drop view with full qualification -->
    <changeSet id="drop-view-full" author="examples">
        <pro-snowflake:dropView
            catalogName="MYDB"
            schemaName="PUBLIC"
            viewName="ACTIVE_CUSTOMERS"
            ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-view",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "viewName": "MY_VIEW",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-view-qualified",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "schemaName": "ANALYTICS",
              "viewName": "SALES_SUMMARY",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-view-full",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "viewName": "ACTIVE_CUSTOMERS",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Drop view with IF EXISTS
  - changeSet:
      id: drop-view
      author: examples
      changes:
        - dropView:
            viewName: MY_VIEW
            ifExists: true

  # Drop view with schema qualification
  - changeSet:
      id: drop-view-qualified
      author: examples
      changes:
        - dropView:
            schemaName: ANALYTICS
            viewName: SALES_SUMMARY
            ifExists: true

  # Drop view with full qualification
  - changeSet:
      id: drop-view-full
      author: examples
      changes:
        - dropView:
            catalogName: MYDB
            schemaName: PUBLIC
            viewName: ACTIVE_CUSTOMERS
            ifExists: true

--liquibase formatted sql

--changeset examples:drop-view-with-if-exists
-- Drop view with IF EXISTS
DROP VIEW IF EXISTS MYDB.PUBLIC.MY_VIEW;

--changeset examples:drop-view-with-schema-qualification
-- Drop view with schema qualification
DROP VIEW IF EXISTS MYDB.ANALYTICS.SALES_SUMMARY;

--changeset examples:drop-view-without-if-exists
-- Drop view without IF EXISTS
DROP VIEW MYDB.PUBLIC.ACTIVE_CUSTOMERS;

<?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">

    <!-- Drop view with IF EXISTS -->
    <changeSet id="drop-view" author="examples">
        <pro-snowflake:dropView
            viewName="MY_VIEW"
            ifExists="true"/>
    </changeSet>

    <!-- Drop view with schema qualification -->
    <changeSet id="drop-view-qualified" author="examples">
        <pro-snowflake:dropView
            schemaName="ANALYTICS"
            viewName="SALES_SUMMARY"
            ifExists="true"/>
    </changeSet>

    <!-- Drop view with full qualification -->
    <changeSet id="drop-view-full" author="examples">
        <pro-snowflake:dropView
            catalogName="MYDB"
            schemaName="PUBLIC"
            viewName="ACTIVE_CUSTOMERS"
            ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-view",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "viewName": "MY_VIEW",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-view-qualified",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "schemaName": "ANALYTICS",
              "viewName": "SALES_SUMMARY",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-view-full",
        "author": "examples",
        "changes": [
          {
            "dropView": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "viewName": "ACTIVE_CUSTOMERS",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Drop view with IF EXISTS
  - changeSet:
      id: drop-view
      author: examples
      changes:
        - dropView:
            viewName: MY_VIEW
            ifExists: true

  # Drop view with schema qualification
  - changeSet:
      id: drop-view-qualified
      author: examples
      changes:
        - dropView:
            schemaName: ANALYTICS
            viewName: SALES_SUMMARY
            ifExists: true

  # Drop view with full qualification
  - changeSet:
      id: drop-view-full
      author: examples
      changes:
        - dropView:
            catalogName: MYDB
            schemaName: PUBLIC
            viewName: ACTIVE_CUSTOMERS
            ifExists: true

--liquibase formatted sql

--changeset examples:drop-view-with-if-exists
-- Drop view with IF EXISTS
DROP VIEW IF EXISTS MYDB.PUBLIC.MY_VIEW;

--changeset examples:drop-view-with-schema-qualification
-- Drop view with schema qualification
DROP VIEW IF EXISTS MYDB.ANALYTICS.SALES_SUMMARY;

--changeset examples:drop-view-without-if-exists
-- Drop view without IF EXISTS
DROP VIEW MYDB.PUBLIC.ACTIVE_CUSTOMERS;

Snowflake dropView

Available attributes

XML example

JSON example

YAML example

SQL example

More like this