所有元素和属性都使用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