modifyDataType
Allows you to modify the data types of columns in a table.
Run modifyDataType
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 | |
| Name of the column | all | all | |
| Data type to convert the column to. Only modifies the data type itself and cannot define constraints | all | all | |
| Name of the schema | all | ||
| Name of the table containing the column whose data type you want to change | all | all |
Database support
Database | Notes | |
DB2/LUW | Supported | No |
DB2/z | Not Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
Google BigQuery | Supported | No |
H2 | Supported | No |
HyperSQL | Supported | No |
INGRES | Supported | No |
Informix | Supported | No |
MariaDB | Supported | No |
MySQL | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Supported | No |
SQL Server | Supported | No |
SQLite | Not Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |
modifyDataType examples
--liquibase formatted sql
--changeset liquibase-docs:modifyDataType-example
ALTER TABLE cat.person MODIFY id INT;