Liquibase ships with a large number of refactoring/changes that can be applied to your database as well as the ability to write more through the extension system.
Entity | Create / Add | Drop | Change |
Table | createTable | dropTable | renameTable setTableRemarks |
Column | addColumn | dropColumn | renameColumn modityDataType setColumnRemarks addAutoIncrement |
Index | createIndex | dropIndex | |
View | createView | dropView | renameView |
Procedure | createProcedure | dropProcedure | |
Sequence | createSequence | dropSequence | renameSequence alterSequence |
Constraint | Add | Drop |
Check | addCheckConstraint | dropConstraint |
Default value | addDefaultValue | dropDefaultValue |
Foreign key | addForeignKeyConstraint | dropForeignKeyConstraint |
Not null | addNotNullConstraint | dropNotNullConstraint |
Primary key | addPrimaryKey | dropPrimaryKey |
Unique key | addUniqueKeyConstraint | dropUniqueKeyConstraint |
Data | ||||||
insert | update | delete | loadData | loadUpdateData | mergeColumns | addLookupTable |
Misc | ||||||
sql | sqlFile | executeCommand | tagDatabase | stop | output | customChange |