添加"ON DELETE CASCADE"到Laravel中的现有列 [英] Add "ON DELETE CASCADE" to existing column in Laravel

问题描述

我的表中有user_id fk列

I have user_id fk column in my table

$table->foreign('user_id')->references('id')->on('users');

我应该在此现有列中添加有关级联删除的功能.我该怎么办?

I should add on cascade delete feature to this existing column. How can I do this?

推荐答案

首先删除外键.感谢剃刀的提示

Drop foreign key first. Thanks to Razor for this tip

$table->dropForeign('answers_user_id_foreign');
$table->foreign('user_id')
->references('id')->on('users')
->onDelete('cascade');

这篇关于添加"ON DELETE CASCADE"到Laravel中的现有列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！