所有元素和属性都使用camelCase格式。
备注：pro 角标是指需Liquibase专业版才支持，Not Supported 是指暂且不支持MySQL数据库。
1.Entities
| 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 | createSequenceNot Supported | dropSequenceNot Supported | renameSequenceNot Supported alterSequenceNot Supported |
| Function | createFunctionpro | dropFunctionpro | 无 |
| Package | createPackagepro createPackageBodypro | dropPackagepro dropPackageBodypro | 无 |
| Synonym | createSynonympro,Not Supported | dropSynonympro,Not Supported | 无 |
| Trigger | createTriggerpro enableTriggerpro,Not Supported | dropTriggerpro disableTriggerpro,Not Supported | renameTriggerpro,Not Supported |
2.Constraints
| Constraint | Add | Drop |
|---|---|---|
| Check | addCheckConstraintNot Supported enableCheckConstraintpro,Not Supported | dropCheckConstraintNot Supported disableCheckConstraintpro,Not Supported |
| Default value | addDefaultValue | dropDefaultValue |
| Foreign key | addForeignKeyConstraint | dropForeignKeyConstraint dropAllForeignKeyConstraints |
| Not null | addNotNullConstraint | dropNotNullConstraint |
| Primary key | addPrimaryKey | dropPrimaryKey |
| Unique key | addUniqueConstraint | dropUniqueConstraint |
3.Data
4.Miscellaneous
原创文章，作者：huoxiaoqiang，如若转载，请注明出处：https://www.huoxiaoqiang.com/experience/javae/16950.html
微信扫一扫 
支付宝扫一扫