How To Drop Foreign Key In Laravel 10 Migration

Websolutionstuff | Apr-28-2023 | Categories : Laravel

In this article, we will explore the process of removing foreign key constraints in Laravel 10 migrations. We will delve into the specific steps for dropping foreign keys in Laravel 10 using migration techniques. To accomplish this, we will utilize the dropForeign method, specifying the name of the foreign key constraint to be deleted as an argument.

It's essential to note that foreign key constraints follow the same naming convention as indexes. Therefore, removing them is not as straightforward as using dropColumn(). Instead, we need to first drop the foreign key constraint using dropForeign(), and then we can proceed to delete the column using dropColumn().

Let's learn how to drop foreign keys in Laravel 10 migrations, understand the methods for removing foreign key constraints, and effectively manage your database schema changes.

$table->dropForeign('posts_user_id_foreign');

Alternatively, you may pass an array containing the column name that holds the foreign key to the dropForeign method. The array will be converted to a foreign key constraint name using Laravel's constraint naming conventions.

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

Example:

Schema::create('users', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
    $table->string('email')->unique();
    $table->string('profile_picture');
    $table->string('password', 60);
    $table->integer('post_id')->unsigned();
    $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
    $table->timestamps();
});

Drop Column Migration:

Schema::table('users', function (Blueprint $table) {
    $table->dropForeign('users_post_id_foreign');
    $table->dropColumn('post_id');
});

 

You might also like:

Recommended Post
Featured Post
How To Redirect Another Page Using Javascript
How To Redirect Another Page U...

In this article, we will see how to redirect another page using javascript. we will redirect the page to another pa...

Read More

Nov-04-2022

How To Get Multiple Checkbox Value In Javascript
How To Get Multiple Checkbox V...

Checkboxes let us make multiple choices. But how do you actually use them in JavaScript? It might seem tricky, especiall...

Read More

Jan-10-2023

How To Two Factor Authentication Using Email In Laravel 10
How To Two Factor Authenticati...

In this article, we will see how to two-factor authentication using email in laravel 10. Here, we will learn about...

Read More

Apr-14-2023

How To Get env Variable In Controller Or Blade File
How To Get env Variable In Con...

In this tutorial, I will give you information on how to get the .env variable in the controller or file. Many times we n...

Read More

Jul-26-2020