DEV Community

Beaver Bridge
Beaver Bridge

Posted on

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

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");
}
Enter fullscreen mode Exit fullscreen mode

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

Top comments (0)