renameView

Last updated: March 26, 2026

Renames an existing view. Liquibase supports views, but does not support materialized views.

Known issue: The Liquibase renameView 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 that you are using the Snowflake renameView change type and breaks backwards compatibility with the Liquibase renameView change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

Run renameView

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	Since
`catalogName`	Name of the catalog		all	3.0
`newViewName`	New name for the view	all	all
`oldViewName`	Existing name of the view to rename	all	all
`schemaName`	Name of the schema		ingres, mariadb, mssql, mysql, postgresql, sqlite, sybase

Database support

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

renameView examples

--liquibase formatted sql

--changeset liquibase-docs:renameView-example
RENAME  TABLE  cat.v_person  TO  cat.v_person;

databaseChangeLog:
-  changeSet:
    id:  renameView-example
    author:  liquibase-docs
    changes:
    -  renameView:
        catalogName:  cat
        newViewName:  v_person
        oldViewName:  v_person
        schemaName:  public

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "renameView-example",
                "author": "liquibase-docs",
                "changes": [
                    {
                        "renameView": {
                            "catalogName": "cat",
                            "newViewName": "v_person",
                            "oldViewName": "v_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="renameView-example">
        <renameView  catalogName="cat"
            newViewName="v_person"
            oldViewName="v_person"
            schemaName="public"/>
    </changeSet>

</databaseChangeLog>

--liquibase formatted sql

--changeset liquibase-docs:renameView-example
RENAME  TABLE  cat.v_person  TO  cat.v_person;

databaseChangeLog:
-  changeSet:
    id:  renameView-example
    author:  liquibase-docs
    changes:
    -  renameView:
        catalogName:  cat
        newViewName:  v_person
        oldViewName:  v_person
        schemaName:  public

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "renameView-example",
                "author": "liquibase-docs",
                "changes": [
                    {
                        "renameView": {
                            "catalogName": "cat",
                            "newViewName": "v_person",
                            "oldViewName": "v_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="renameView-example">
        <renameView  catalogName="cat"
            newViewName="v_person"
            oldViewName="v_person"
            schemaName="public"/>
    </changeSet>

</databaseChangeLog>

renameView

Run renameView

Available attributes

Database support

renameView examples

SQL example

YAML example

JSON example

XML example