Drop foreign key column in Laravel using migration

• Drop foreign key constraint posts_user_id_foreign from posts table with column in Laravel using migration

  --PATH database\migrations\<2021_11_15_101237_drop_posts_user_id_foreign_from_posts>.php

  public function up(){
      Schema::table('posts', function(Blueprint $table){
          $table->dropForeign('posts_user_id_foreign');
          $table->dropColumn('user_id');
      });
  }
  

  To get the foreign key constraint, click on table in the specific database and click on relation view after click on structure of the table.

  Create migration file using php artisan make:migration drop_posts_user_id_foreign_from_posts --table=posts command.

  Add the foreign key constraint to the dropForeign method which you want to drop and run migration command to drop the column and foreign key constraint.

• Drop foreign key constraint with index and column in Laravel using migration

  --PATH database\migrations\<2021_11_15_101237_drop_posts_user_id_foreign_from_posts>.php

  public function up(){
      Schema::table('posts', function(Blueprint $table){
          $table->dropForeign('posts_user_id_foreign');
          $table->dropIndex('posts_user_id_foreign');
          $table->dropColumn('user_id');
      });
  }
  

  Using this code snippet you can drop foreign key column with index and constraint name in Laravel.

  To get the foreign key constraint, click on table in the specific database and click on relation view after click on structure of the table.

  Create migration file using php artisan make:migration drop_posts_user_id_foreign_from_posts --table=posts command.

  Add the foreign key constraint to the dropForeign method which you want to drop and run migration command to drop the column and foreign key constraint.

Back to code snippet queries related laravel