renameView
Renames an existing view.Liquibase supports views, but does not support materialized views.
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 |
| Name of the catalog | all | 3.0 | |
| New name for the view | all | all | |
| Existing name of the view to rename | all | all | |
| Name of the schema | ingres, mariadb, mssql, mysql, postgresql, sqlite, sybase |
Database support
Database | Notes | |
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;