Search by Queries/Bugs/Errors

Drop foreign key column in Laravel using migration

You can drop foreign key column with constraints in Laravel using migration, you have to create migration file and add dropForeign() and dropColumn() method inside up or down function in migration file and run migration command to drop the column.

Answers 2

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');
    });
}
```
0

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');
    });
}
```
0

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

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress

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

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