Search by Queries/Bugs/Errors

laravel migration add foreign key to existing table

Created at 26-Jul-2021 , By samar

In this session, we’ll try our hand at solving the "laravel migration add foreign key to existing table" puzzle by using the computer language.

You can add a foreign key to the existing table in laravel using migration. Laravel provides migration column type foreginId() which helps you to create a foreign key in an already existing table in your database.

Create foreign key to an existing table in laravel 8

//Create migration file
php artisan make:migration add_user_id_to_posts_table --table=posts

//Create table structure using column type in the generated migration file
//database\migrations\<2021_07_26_032616>_add_user_id_to_posts_table.php
public function up()
{
    Schema::table('posts', function (Blueprint $table) {
        $table->foreignId('user_id')->constrained();
    });
}

/**
    * Reverse the migrations.
    *
    * @return void
    */
public function down()
{
    Schema::table('posts', function (Blueprint $table) {
        $table->dropForeign(['user_id']);
    });
}

//Run artisan command to create a foreign key
php artisan migrate

Laravel 8 has a foreignId() column type in migration schema builder. Which is used to create a foreign key in laravel with an UNSIGNED BIGINT equivalent column.

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.

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

laravel migration add foreign key to existing table

Create foreign key to an existing table in laravel 8

Related Queries

Random Code Snippet Queries: Laravel

Latest Code Snippets