Change Types
A Change Type is an XML, YAML, or JSON formatted change that you can specify to update your database with Liquibase. Change Types correspond to SQL statements applied to your database, such as CREATE TABLE. You specify the Change Type you want to use within a Changeset in your Changelog. It is a best practice to include only one Change Type per changeset.
This page lists all changes that you can apply to your database with the default Liquibase installation. You can also write your own changes through the extension system.
For a guide on using Change Types with Liquibase, see Migrating with Liquibase Change Types. If your changelogs are written in SQL, see Migrating with SQL.
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 Automatic and Custom Rollbacks.
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 |