Laravel migration : Remove onDelete('cascade') from existing foreign key

Question

I have created a migration like this :

// ...
$table->foreign('a')->references('b')->on('c')->onDelete('cascade');
// ...

I want to remove the onDelete('cascade') in a new migration without breaking anything. How can I do that ?

Answer 1

You can try to remove the old foreign key and add then add a new one without onDelete:

$table->dropForeign(['a']);
$table->foreign('a')->references('b')->on('c');