Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
How to drop foreign key in laravel migration

How to drop foreign key in laravel migration ?

Aman Jain, September 28, 2022March 16, 2024

Drop foreign key to existing table are easy as creating a foreign key and adding columns to it. In laravel migration we can drop foreign key in laravel migration to existing table using dropForeign method of migration class. Major difference between creating new table and updating new table is Schema::create and Schema::table In this tutorial we will create a new migration file and then will drop foreign key column user_id to the existing table .

I hope you know about How to make database connection in Laravel 8 ?

We will use the php artisan command to generate the drop foreign key in laravel migration and php artisan migrate command to modify the table.

I am assuming that you have already table movies and user_id column with foreign key in database and now we are deleting foreign key.

Also you can read How to add column in laravel migration ?

Steps to drop foreign key in laravel migration

Let’s understand the drop foreign key in laravel migration step by step

Step 1 : Generate migration file

To generate the migration file we will use the laravel artisan command so open the terminal in project and run below command

php artisan make:migration DeleteForeignUserIdMoviesTable

Above command will create a migration file in folder database/migrations

Output: 
Created Migration: 2022_02_17_172323_delete_foreign_user_id_movies_table

Step 2 : Open generated migration file and update

In the last step we created a migration file using the artisan command and now we wanted to drop foreign keyto schema of movies table.

so let’s open the file and start editing

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class DeleteForeignUserIdMoviesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}

In the file there is a class named as DeleteForeignUserIdMoviesTable and it extends Migration class. DeleteForeignUserIdMoviesTable class contains two methods one is up and other one is down.

Up is used to update the database scheme and down method is used to rollback the changes of this migration. As you can see we are creating table movies in up method and dropping the table in down method.

let’s add remove the foreign key using dropForeign method from our table before updating the database.

 public function up()
 {
        Schema::table('movies', function (Blueprint $table) {
            
            $table->dropForeign(['user_id', 'another_column']);
        });
 }
 public function down()
 {
        Schema::table('movies', function (Blueprint $table) {
              $table->integer('user_id');
        });
 }

Here we used Schema::table to update the table.

Step 3 : Run Migration

In this step we will execute our migration in database using below command

php artisan migrate

This will create table in database and the output

Output: 
Migrating: 2022_02_17_172323_delete_foreign_user_id_movies_table
Migrated:  2022_02_17_172323_delete_foreign_user_id_movies_table (27.20ms)

Screenshot After:

laravel migration phpmyadmin
laravel migration phpmyadmin

Also Read : How to add column in laravel migration ?

Related

Php Laravel columndeleteforeignlaravelmigrationphp

Post navigation

Previous post
Next post

Related Posts

Php Laravel Rest Api OTP Login and Registration Without Password

Laravel Rest Api OTP Login and Registration Without Password

September 3, 2022March 16, 2024

Today most of the applications are using laravel rest api otp login and registration without password for ease of login and registration and also provides easy to login without remembering the password each time while login or register. In Laravel there is multiple ways to implement the login and registration…

Read More
Php Laravel having in eloquent with example

How to use laravel having with example ?

January 22, 2022January 22, 2022

MySQL having is used to filter records based on the condition passes but it applies on last of query, where we can access aggregated function of select query. so to create the having query we used having method in laravel. laravel having method accepts multiple parameter same as laravel where….

Read More
Php How to Show Human Readable Date in Ago Format in Laravel

How to Show Human Readable Date in Ago Format in Laravel ?

September 5, 2022March 16, 2024

In this article we will learn to show human readable date in ago format in laravel. Its best way to show the ago date on our application since its human readable and we don’t need to care about timezones because we can keep any timezone and it will always show…

Read More

Aman Jain
Aman Jain

With years of hands-on experience in the realm of web and mobile development, they have honed their skills in various technologies, including Laravel, PHP CodeIgniter, mobile app development, web app development, Flutter, React, JavaScript, Angular, Devops and so much more. Their proficiency extends to building robust REST APIs, AWS Code scaling, and optimization, ensuring that your applications run seamlessly on the cloud.

Categories

  • Angular
  • CSS
  • Dart
  • Devops
  • Flutter
  • HTML
  • Javascript
  • jQuery
  • Laravel
  • Laravel 10
  • Laravel 11
  • Laravel 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • October 2024
  • July 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • March 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Recent Posts

  • Mapping Together: The Vibrant Spirit of OpenStreetMap Japan
  • Understanding High Vulnerabilities: A Deep Dive into the Weekly Summary
  • Building a Million-Dollar Brand: The Journey of Justin Jackson
  • Mastering Schedule Management with Laravel Zap
  • The Resilience of Nature: How Forests Recover After Fires
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version