Name: [Sequelize + mariaDB] index 걸린 컬럼 삭제하기
Rating: 3.1 (2952 reviews)
Author: __aa3e4bc832ba7032bfa3

[Sequelize + mariaDB] index 걸린 컬럼 삭제하기

Beaver Bridge - Apr 28 -

- Dev Community

index가 걸린 필드를 삭제할 때 Cannot drop index 'notices_approval_id_foreign_idx': needed in a foreign key constraint 에러가 뜬다.

async down(queryInterface, Sequelize) {
  await queryInterface.sequelize.query(
    "ALTER TABLE notices DROP CONSTRAINT if exists notices_approval_id_foreign_idx",
  );
  await queryInterface.sequelize.query("ALTER TABLE notices DROP COLUMN if exists approval_id");
}

원래는 removeConstraint, removeColumn 을 사용해야하는데, 안돼서 쿼리를 직접 사용해야 한다.