Laravel :: Best way to update a foreign key

Question

I have this migration file

Schema::create('table_one', function(Blueprint $table)  {      $table->increments('id');      $table->string('name');      $table->integer('table_two_id')->unsigned();      $table->foreign('table_two_id')->references('id')->on('table_two');      $table->timestamps();  }); 

and I want to update to make it ->onDelete('cascade');

$table->foreign('table_two_id')->references('id')->on('table_two')->onDelete('cascade'); 

What is the best way to do this?

Is there something like ->change();

Thanks

Answer 1

Drop the foreign key then add it again and run migrate.

public function up() {     Schema::table('table_one', function (Blueprint $table) {         $table->dropForeign(['table_two_id']);          $table->foreign('table_two_id')             ->references('id')             ->on('table_two')             ->onDelete('cascade');     }); } 

Answer 2

Christopher K. is right, at the Laravel docs says:

To drop a foreign key, you may use the dropForeign method. Foreign key constraints use the same naming convention as indexes. So, we will concatenate the table name and the columns in the constraint then suffix the name with "_foreign":

$table->dropForeign('posts_user_id_foreign');  

Or, you may pass an array value which will automatically use the conventional constraint name when dropping:

$table->dropForeign(['user_id']); 

https://laravel.com/docs/5.7/migrations#foreign-key-constraints