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.

Note

  • Property values are string except noted
  • Boolean parameters are defaulted to false unless otherwise noted

Community Change Types

Pro Change Types

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

 

Constraint Add Drop
Check addCheckConstraint dropCheckConstraint
Default value addDefaultValue dropDefaultValue
Foreign key addForeignKeyConstraint dropForeignKeyConstraint
Not null addNotNullConstraint dropNotNullConstraint
Primary key addPrimaryKey dropPrimaryKey
Unique key addUniqueConstraint dropUniqueConstraint

 

Data            
insert update delete loadData loadUpdateData mergeColumns addLookupTable

 

Misc            
sql sqlFile executeCommand tagDatabase stop output customChange