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 Liquibase Auto Rollback.
Entities
Entity | Create/Add | Drop | Change |
---|---|---|---|
Table | createTable | dropTable | |
Column | addColumn | dropColumn | |
Index | createIndex | dropIndex | |
View | createView | dropView | renameView |
Procedure | createProcedure | dropProcedure | |
Sequence | createSequence | dropSequence | |
Function | createFunction![]() |
dropFunction![]() |
|
Package | |||
Synonym | createSynonym![]() |
dropSynonym![]() |
|
Trigger | renameTrigger![]() |
Constraints
Constraint | Add | Drop |
---|---|---|
Check | ||
Default value | addDefaultValue | dropDefaultValue |
Foreign key | addForeignKeyConstraint | |
Not null | addNotNullConstraint | dropNotNullConstraint |
Primary key | addPrimaryKey | dropPrimaryKey |
Unique key | addUniqueConstraint | dropUniqueConstraint |