Reference
Version · 6.0
Change Automation Reference

renameTable

Last updated: August 12, 2026

Renames an existing table.

Run renameTable

To run this Change Type, follow these steps:

Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the update command:liquibase update

Available attributes

Name	Description	Required for	Supports
`catalogName`	Name of the catalog		all
`newTableName`	New name for the table	all	all
`oldTableName`	Existing name of the table to rename	all	all
`schemaName`	Name of the schema		all

Database support

Database	Notes	Auto Rollback
DB2/LUW	Supported	Yes
DB2/z	Supported	Yes
Derby	Supported	Yes
Firebird	Not Supported	No
Google BigQuery	Supported	Yes
H2	Supported	Yes
HyperSQL	Supported	Yes
INGRES	Supported	Yes
Informix	Supported	Yes
MariaDB	Supported	Yes
MySQL	Supported	Yes
Oracle	Supported	Yes
PostgreSQL	Supported	Yes
Snowflake	Supported	Yes
SQL Server	Supported	Yes
SQLite	Supported	Yes
Sybase	Supported	Yes
Sybase Anywhere	Supported	Yes

renameTable examples

--liquibase formatted sql

--changeset liquibase-docs:renameTable-example
ALTER  TABLE  cat.person  RENAME TO  cat.employee;

databaseChangeLog:
-  changeSet:
    id:  renameTable-example
    author:  liquibase-docs
    changes:
    -  renameTable:
        catalogName:  cat
        newTableName:  employee
        oldTableName:  person
        schemaName:  public

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "renameTable-example",
                "author": "liquibase-docs",
                "changes": [
                    {
                        "renameTable": {
                            "catalogName": "cat",
                            "newTableName": "employee",
                            "oldTableName": "person",
                            "schemaName": "public"
                        }
                    }
                ]
            }
        }
    ]
}

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    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/dbchangelog-ext
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

    <changeSet  author="liquibase-docs"  id="renameTable-example">
        <renameTable  catalogName="cat"
            newTableName="employee"
            oldTableName="person"
            schemaName="public"/>
    </changeSet>

</databaseChangeLog>

--liquibase formatted sql

--changeset liquibase-docs:renameTable-example
ALTER  TABLE  cat.person  RENAME TO  cat.employee;

databaseChangeLog:
-  changeSet:
    id:  renameTable-example
    author:  liquibase-docs
    changes:
    -  renameTable:
        catalogName:  cat
        newTableName:  employee
        oldTableName:  person
        schemaName:  public

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "renameTable-example",
                "author": "liquibase-docs",
                "changes": [
                    {
                        "renameTable": {
                            "catalogName": "cat",
                            "newTableName": "employee",
                            "oldTableName": "person",
                            "schemaName": "public"
                        }
                    }
                ]
            }
        }
    ]
}

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    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/dbchangelog-ext
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro
        http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

    <changeSet  author="liquibase-docs"  id="renameTable-example">
        <renameTable  catalogName="cat"
            newTableName="employee"
            oldTableName="person"
            schemaName="public"/>
    </changeSet>

</databaseChangeLog>

PreviousRenameSequence NextRenameTrigger

renameTable

Run renameTable

Available attributes

Database support

renameTable examples

SQL example

YAML example

JSON example

XML example