Reference
Version · 6.0
Change Automation Reference

Alter Standard Table - Swap

Last updated: August 12, 2026

Swaps the table with another table. This operation exchanges the table names and metadata atomically.

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.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the table	No
`schemaName`	String	Name of the schema containing the table	No
`tableName`	String	Name of the table to alter	Yes
`ifExists`	Boolean	Only execute if the table exists	No

swapWith nested attributes

Attribute	Type	Description	Required
`targetTable`	String	Name of the table to swap with	Yes

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

    <!-- Simple swap -->
    <changeSet id="swap-tables" author="examples">
        <pro-snowflake:alterStandardTable tableName="PRODUCTION_TABLE">
            <pro-snowflake:swapWith targetTable="STAGING_TABLE"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

    <!-- Blue/green deployment swap -->
    <changeSet id="swap-blue-green" author="examples">
        <pro-snowflake:alterStandardTable
            schemaName="PROD"
            tableName="ACTIVE_TABLE">
            <pro-snowflake:swapWith targetTable="NEW_VERSION_TABLE"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "swap-tables",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "tableName": "PRODUCTION_TABLE",
              "swapWith": {
                "targetTable": "STAGING_TABLE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "swap-blue-green",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "schemaName": "PROD",
              "tableName": "ACTIVE_TABLE",
              "swapWith": {
                "targetTable": "NEW_VERSION_TABLE"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple swap
  - changeSet:
      id: swap-tables
      author: examples
      changes:
        - alterStandardTable:
            tableName: PRODUCTION_TABLE
            swapWith:
              targetTable: STAGING_TABLE

  # Blue/green deployment swap
  - changeSet:
      id: swap-blue-green
      author: examples
      changes:
        - alterStandardTable:
            schemaName: PROD
            tableName: ACTIVE_TABLE
            swapWith:
              targetTable: NEW_VERSION_TABLE

--liquibase formatted sql

--changeset examples:simple-swap
-- Simple swap
ALTER TABLE MYDB.PUBLIC.PRODUCTION_TABLE SWAP WITH STAGING_TABLE;

--changeset examples:swap-with-schema-specified
-- Swap with schema specified
ALTER TABLE MYDB.PROD.ACTIVE_TABLE SWAP WITH NEW_VERSION_TABLE;

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

    <!-- Simple swap -->
    <changeSet id="swap-tables" author="examples">
        <pro-snowflake:alterStandardTable tableName="PRODUCTION_TABLE">
            <pro-snowflake:swapWith targetTable="STAGING_TABLE"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

    <!-- Blue/green deployment swap -->
    <changeSet id="swap-blue-green" author="examples">
        <pro-snowflake:alterStandardTable
            schemaName="PROD"
            tableName="ACTIVE_TABLE">
            <pro-snowflake:swapWith targetTable="NEW_VERSION_TABLE"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "swap-tables",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "tableName": "PRODUCTION_TABLE",
              "swapWith": {
                "targetTable": "STAGING_TABLE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "swap-blue-green",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "schemaName": "PROD",
              "tableName": "ACTIVE_TABLE",
              "swapWith": {
                "targetTable": "NEW_VERSION_TABLE"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple swap
  - changeSet:
      id: swap-tables
      author: examples
      changes:
        - alterStandardTable:
            tableName: PRODUCTION_TABLE
            swapWith:
              targetTable: STAGING_TABLE

  # Blue/green deployment swap
  - changeSet:
      id: swap-blue-green
      author: examples
      changes:
        - alterStandardTable:
            schemaName: PROD
            tableName: ACTIVE_TABLE
            swapWith:
              targetTable: NEW_VERSION_TABLE

--liquibase formatted sql

--changeset examples:simple-swap
-- Simple swap
ALTER TABLE MYDB.PUBLIC.PRODUCTION_TABLE SWAP WITH STAGING_TABLE;

--changeset examples:swap-with-schema-specified
-- Swap with schema specified
ALTER TABLE MYDB.PROD.ACTIVE_TABLE SWAP WITH NEW_VERSION_TABLE;

PreviousAlter standard table - rename NextAlterStreamComment

Alter Standard Table - Swap

Available attributes

swapWith nested attributes

XML

JSON

YAML

SQL

More like this

alterStandardTable renameTo

alterDynamicTable swapWith

Snowflake: ALTER TABLE