How to remove ->onDelete('set null') in migration?

Question

Laravel

$table->foreignId('user_id')->nullable()->constrained('users')->onDelete('set null');

I have a user_id column with ->onDelete('set null'), but with softDelete, I don't want the column to be cleared
. How can I remove this or how can I remove "->onDelete('set null')" in a new migration?

Answer 1

With softDelete, the record is not deleted, only the deleted_at field is filled.
Therefore, the onDelete('set null') trigger does not fire and the value is not set to zero.