liquibase 删除表PK
liquibase 删除表PK
databaseChangeLog:
- changeSet:
id: xxx_0.0.1_drop_pk
author: username
comment: xxx table drop primary key
dbms: oracle
changes:
- dropPrimaryKey:
constraintName: PK_NAME
dropIndex: true
tableName: TABLE_NAME
schemaName: public
SQL 描述
ALTER TABLE TABLE_NAME DROP PRIMARY KEY;