Skip to content
Readerstacks logo Readerstacks
  • Home
  • Softwares
  • Angular
  • Php
  • Laravel
  • Flutter
Readerstacks logo
Readerstacks
How to delete column in laravel migration ?

How to delete column in laravel migration ?

Aman Jain, February 17, 2022February 17, 2022

Deleting column to existing table are easy as creating a new table and adding columns to it. In laravel migration we can delete colum to existing table using the same method we used in create migrations . 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 delete a column status 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 delete column in laravel migration and php artisan migrate command to modify the table.

I am assuming that you have already table movies in database and now we are deleting column. also you can read How to add column in laravel migration ?

Let’s understand the delete column in laravel migration in laravel 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 DeleteStatusMoviesTable

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

Output: 
Created Migration: 2022_02_17_172323_delete_status_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 delete column to 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 DeleteStatusMoviesTable 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 DeleteStatusMoviesTable and it extends Migration class. DeleteStatusMoviesTable 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 delete the column using dropColumn method from our table before updating the database.

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

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_status_movies_table
Migrated:  2022_02_17_172323_delete_status_movies_table (27.20ms)

Screenshot Before:

laravel migration  phpmyadmin
laravel migration phpmyadmin

Screenshot After:

laravel migration phpmyadmin
laravel migration phpmyadmin

Delete foreign key before deleting column

Sometime we create foreign keys to create the relation in database so if we delete the column without deleting the relation then it produce error so to eliminate this we can delete foreign key first using dropForeign method as below

 public function up()
 {
        Schema::table('movies', function (Blueprint $table) {
           
           $table->dropForeign('statusFk');
           $table->dropColumn('status');
            
        });
 }
 

Also Read : How to add column in laravel migration ?

Share this:

  • Facebook
  • X

Related

Php Laravel deletelaravelmigrationphp

Post navigation

Previous post
Next post

Related Posts

Uncategorized Custom middleware in laravel

How to create custom middleware Laravel 8

October 15, 2021November 6, 2023

In this tutorial we will going to learn custom middleware Laravel 8. Middleware are used to create a layer between request and response of the http request. it filters or create a logic before the request serve to the controller and also filter or modify the response. we can also…

Share this:

  • Facebook
  • X
Read More
Php How to Upload image with preview in Laravel 8 with example

How to Upload image with preview in Laravel 8 with example ?

May 14, 2022August 20, 2022

Upload image with preview in laravel or for any website can be basic requirement like set up a profile picture to providing the documents. Laravel provides robust functionality to upload and process the image with security. Laravel simply use Request file method to access the uploaded file and then we…

Share this:

  • Facebook
  • X
Read More
Laravel Get Domain Name in Laravel

How to Get Domain Name in Laravel ?

November 27, 2023November 27, 2023

In this blog post we will learn to get domain name in laravel. Laravel inbuilt library for handling the request and response can do this task very seamlessly. A domain name is the human-readable address that users enter into their browsers to access a website. Knowing the domain name is…

Share this:

  • Facebook
  • X
Read More

Leave a ReplyCancel reply

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 9
  • Mysql
  • Php
  • Softwares
  • Ubuntu
  • Uncategorized

Archives

  • 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

  • How to Call Controller Method from Another Controller in Laravel ?
  • How to Get Domain Name in Laravel ?
  • How to Append Query String to Route in Laravel ?
  • How to Append URL Query Params to Pagination Laravel ?
  • How to Get Today Records in Laravel ?
©2023 Readerstacks | Design and Developed by Readerstacks
Go to mobile version