markUnused
Note: This is a Liquibase Pro Change Type, so you need a Liquibase Pro License Key to use it.
The markUnused Change Type is an Oracle-specific Change Type that marks a column as unused. The markUnused Change Type helps to avoid database slowdowns caused by dropping a populated column.
Uses
You can typically use the markUnused Change Type to mark columns as unused rather than dropping them immediately, which allows you to decide the best time to drop those columns.
Run markUnused
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
updatecommand:liquibase update
Available attributes
Name | Description | Required for | Supports |
| Name of the catalog | all | |
| Name of the column | all | all |
| Name of the schema | all | |
| Name of the table | all | all |
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 | No |
H2 | Not Supported | No |
HyperSQL | Not Supported | No |
INGRES | Not Supported | No |
Informix | Not Supported | No |
MariaDB | Not Supported | No |
MySQL | Not Supported | No |
Oracle | Supported | No |
PostgreSQL | Not Supported | No |
Snowflake | Not Supported | No |
SQL Server | Not Supported | No |
SQLite | Not Supported | No |
Sybase | Not Supported | No |
Sybase Anywhere | Not Supported | No |
markUnused examples
--liquibase formatted sql
--changeset liquibase-docs:markUnused-example
ALTER TABLE cat.person
SET
UNUSED COLUMN id;