liquibase 删除表PK

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;