Liquibase Change Types一览表

所有元素和属性都使用camelCase格式。

备注:pro 角标是指需Liquibase专业版才支持,Not Supported 是指暂且不支持MySQL数据库。

1.Entities

EntityCreate/AddDropChange
TablecreateTabledropTablesetTableRemarks
renameTable
ColumnaddColumndropColumnrenameColumn
modifyDataType
setColumnRemarks
addAutoIncrement
IndexcreateIndexdropIndex 无
ViewcreateViewdropViewrenameView
ProcedurecreateProceduredropProcedure 无
SequencecreateSequenceNot SupporteddropSequenceNot SupportedrenameSequenceNot Supported
alterSequenceNot Supported
FunctioncreateFunctionprodropFunctionpro
PackagecreatePackagepro
createPackageBodypro
dropPackagepro
dropPackageBodypro
SynonymcreateSynonympro,Not SupporteddropSynonympro,Not Supported
TriggercreateTriggerpro
enableTriggerpro,Not Supported
dropTriggerpro
disableTriggerpro,Not Supported
renameTriggerpro,Not Supported

2.Constraints

ConstraintAddDrop
CheckaddCheckConstraintNot Supported
enableCheckConstraintpro,Not Supported
dropCheckConstraintNot Supported
disableCheckConstraintpro,Not Supported
Default valueaddDefaultValuedropDefaultValue
Foreign keyaddForeignKeyConstraintdropForeignKeyConstraint
dropAllForeignKeyConstraints
Not nulladdNotNullConstraintdropNotNullConstraint
Primary keyaddPrimaryKeydropPrimaryKey
Unique keyaddUniqueConstraintdropUniqueConstraint

3.Data

4.Miscellaneous

原创文章,作者:huoxiaoqiang,如若转载,请注明出处:https://www.huoxiaoqiang.com/experience/javae/16950.html

(0)
上一篇 2022年8月2日 16:02
下一篇 2022年8月3日 15:56

相关推荐

发表回复

登录后才能评论