Liquibase Change Types

Liquibase ships with a large number of changes that can be applied to your database as well as the ability to write more through the extension system.

Notes

  • Property values are string unless otherwise noted.
  • Boolean parameters are defaulted to false unless otherwise noted.
  • Some change types automatically create rollback statements when you run rollback commands. For more information, see Liquibase Rollback Workflow and Auto Rollback.

Entities

Entity Create/Add Drop Change
Table createTable dropTable

setTableRemarks

renameTable

Column addColumn dropColumn

renameColumn

modifyDataType

setColumnRemarks

addAutoIncrement

Index createIndex dropIndex  
View createView dropView renameView
Procedure createProcedure dropProcedure  
Sequence createSequence dropSequence

renameSequence

alterSequence

Function createFunction dropFunction
Package

createPackage

createPackageBody

dropPackage

dropPackageBody

Synonym createSynonym dropSynonym
Trigger

createTrigger

enableTrigger

dropTrigger

disableTrigger

renameTrigger

Constraints

Constraint Add Drop
Check

addCheckConstraint

enableCheckConstraint

dropCheckConstraint

disableCheckConstraint

Default value addDefaultValue dropDefaultValue
Foreign key addForeignKeyConstraint

dropForeignKeyConstraint

dropAllForeignKeyConstraints

Not null addNotNullConstraint dropNotNullConstraint
Primary key addPrimaryKey dropPrimaryKey
Unique key addUniqueConstraint dropUniqueConstraint

Data

Miscellaneous

Related links