Liquibase® version 3.8.5 is now available! Get it for free.
2018 XML Announcement
News All Previous Posts >>

Subscribe for email updates

- and/or -

Change: ‘markUnused’

Marks Column Unused

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall
columnNameName of the columnallall
schemaNameName of the schemaall
tableNameName of the tableallall
<changeSet author="liquibase-docs" id="markUnused-example">
    <pro:markUnused catalogName="cat"
            columnName="id"
            schemaName="public"
            tableName="person"/>
</changeSet>
changeSet:
  id: markUnused-example
  author: liquibase-docs
  changes:
  - markUnused:
      catalogName: cat
      columnName: id
      schemaName: public
      tableName: person
{
  "changeSet": {
    "id": "markUnused-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "markUnused": {
          "catalogName": "cat",
          "columnName": "id",
          "schemaName": "public",
          "tableName": "person"
        }
      }]
    
  }
}

SQL Generated From Above Sample (Oracle)

ALTER TABLE cat.person SET UNUSED COLUMN id;

Database Support

DatabaseNotesAuto Rollback
DB2/LUWNot SupportedNo
DB2/zNot SupportedNo
DerbyNot SupportedNo
FirebirdNot SupportedNo
H2Not SupportedNo
HyperSQLNot SupportedNo
INGRESNot SupportedNo
InformixNot SupportedNo
MariaDBNot SupportedNo
MySQLNot SupportedNo
OracleSupportedNo
PostgreSQLNot SupportedNo
SQL ServerNot SupportedNo
SQLiteNot SupportedNo
SybaseNot SupportedNo
Sybase AnywhereNot SupportedNo