renameColumn
Renames an existing column.
Available attributes
catalogName |
Name of the catalog |
|
all |
3.0 |
columnDataType |
Data type of the column |
mariadb, mysql |
all |
|
newColumnName |
Name to rename the column to |
all |
all |
|
oldColumnName |
Name of the existing column to rename |
all |
all |
|
remarks |
Remarks of the column |
|
all |
|
schemaName |
Name of the schema |
|
all |
|
tableName |
Name of the table containing that the column to rename |
all |
all |
|
XML example
<changeSet author="liquibase-docs" id="renameColumn-example">
<renameColumn catalogName="cat"
columnDataType="int"
newColumnName="full_name"
oldColumnName="name"
remarks="A String"
schemaName="public"
tableName="person"/>
</changeSet>
YAML example
changeSet:
id: renameColumn-example
author: liquibase-docs
changes:
- renameColumn:
catalogName: cat
columnDataType: int
newColumnName: full_name
oldColumnName: name
remarks: A String
schemaName: public
tableName: person
JSON example
{ "changeSet": { "id": "renameColumn-example", "author": "liquibase-docs", "changes": [ { "renameColumn": { "catalogName": "cat", "columnDataType": "int", "newColumnName": "full_name", "oldColumnName": "name", "remarks": "A String", "schemaName": "public", "tableName": "person" } }] } }
SQL example
ALTER TABLE cat.person CHANGE name full_name INT COMMENT 'A String';
Database support
DB2/LUW |
Supported
|
Yes
|
DB2/z |
Supported
|
Yes
|
Derby |
Supported
|
Yes
|
Firebird |
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
|
SQL Server |
Supported
|
Yes
|
SQLite |
Not Supported |
Yes
|
Sybase |
Supported
|
Yes
|
Sybase Anywhere |
Supported
|
Yes
|