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