Reference
Version · 6.0
Change Automation Reference

Alter Standard Table - Rename

Last updated: August 12, 2026

Renames a standard table to a new name and optionally moves it to a different schema or catalog.

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

renameTo nested attributes

Attribute	Type	Description	Required
`newName`	String	New name for the table	Yes
`newCatalogName`	String	New catalog (database) name	No
`newSchemaName`	String	New schema name	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">

    <!-- Simple rename -->
    <changeSet id="rename-table" author="examples">
        <pro-snowflake:alterStandardTable tableName="OLD_TABLE_NAME">
            <pro-snowflake:renameTo newName="NEW_TABLE_NAME"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

    <!-- Rename and move to different schema -->
    <changeSet id="rename-and-move-table" author="examples">
        <pro-snowflake:alterStandardTable
            catalogName="MY_DATABASE"
            schemaName="OLD_SCHEMA"
            tableName="MY_TABLE">
            <pro-snowflake:renameTo
                newName="MY_RENAMED_TABLE"
                newSchemaName="NEW_SCHEMA"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-table",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "tableName": "OLD_TABLE_NAME",
              "renameTo": {
                "newName": "NEW_TABLE_NAME"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-and-move-table",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "catalogName": "MY_DATABASE",
              "schemaName": "OLD_SCHEMA",
              "tableName": "MY_TABLE",
              "renameTo": {
                "newName": "MY_RENAMED_TABLE",
                "newSchemaName": "NEW_SCHEMA"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-table
      author: examples
      changes:
        - alterStandardTable:
            tableName: OLD_TABLE_NAME
            renameTo:
              newName: NEW_TABLE_NAME

  # Rename and move to different schema
  - changeSet:
      id: rename-and-move-table
      author: examples
      changes:
        - alterStandardTable:
            catalogName: MY_DATABASE
            schemaName: OLD_SCHEMA
            tableName: MY_TABLE
            renameTo:
              newName: MY_RENAMED_TABLE
              newSchemaName: NEW_SCHEMA

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER TABLE MYDB.PUBLIC.OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER TABLE IF EXISTS MYDB.PUBLIC.OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME;

--changeset examples:rename-and-move-to-different-schema
-- Rename and move to different schema
ALTER TABLE MY_DATABASE.OLD_SCHEMA.MY_TABLE RENAME TO MY_DATABASE.NEW_SCHEMA.MY_RENAMED_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 rename -->
    <changeSet id="rename-table" author="examples">
        <pro-snowflake:alterStandardTable tableName="OLD_TABLE_NAME">
            <pro-snowflake:renameTo newName="NEW_TABLE_NAME"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

    <!-- Rename and move to different schema -->
    <changeSet id="rename-and-move-table" author="examples">
        <pro-snowflake:alterStandardTable
            catalogName="MY_DATABASE"
            schemaName="OLD_SCHEMA"
            tableName="MY_TABLE">
            <pro-snowflake:renameTo
                newName="MY_RENAMED_TABLE"
                newSchemaName="NEW_SCHEMA"/>
        </pro-snowflake:alterStandardTable>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "rename-table",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "tableName": "OLD_TABLE_NAME",
              "renameTo": {
                "newName": "NEW_TABLE_NAME"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "rename-and-move-table",
        "author": "examples",
        "changes": [
          {
            "alterStandardTable": {
              "catalogName": "MY_DATABASE",
              "schemaName": "OLD_SCHEMA",
              "tableName": "MY_TABLE",
              "renameTo": {
                "newName": "MY_RENAMED_TABLE",
                "newSchemaName": "NEW_SCHEMA"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Simple rename
  - changeSet:
      id: rename-table
      author: examples
      changes:
        - alterStandardTable:
            tableName: OLD_TABLE_NAME
            renameTo:
              newName: NEW_TABLE_NAME

  # Rename and move to different schema
  - changeSet:
      id: rename-and-move-table
      author: examples
      changes:
        - alterStandardTable:
            catalogName: MY_DATABASE
            schemaName: OLD_SCHEMA
            tableName: MY_TABLE
            renameTo:
              newName: MY_RENAMED_TABLE
              newSchemaName: NEW_SCHEMA

--liquibase formatted sql

--changeset examples:simple-rename
-- Simple rename
ALTER TABLE MYDB.PUBLIC.OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME;

--changeset examples:rename-with-if-exists
-- Rename with IF EXISTS
ALTER TABLE IF EXISTS MYDB.PUBLIC.OLD_TABLE_NAME RENAME TO NEW_TABLE_NAME;

--changeset examples:rename-and-move-to-different-schema
-- Rename and move to different schema
ALTER TABLE MY_DATABASE.OLD_SCHEMA.MY_TABLE RENAME TO MY_DATABASE.NEW_SCHEMA.MY_RENAMED_TABLE;

PreviousAlter standard table - policies NextAlter standard table - swap

Alter Standard Table - Rename

Available attributes

renameTo nested attributes

XML

JSON

YAML

SQL

More like this

alterStandardTable swapWith

alterDynamicTable renameTo

Snowflake: ALTER TABLE