In this engaging blog post, you can explain how to remove columns from database tables in a Laravel application using migrations. The article should provide readers with a clear, step-by-step guide while keeping their interest piqued with engaging content.
I will give you some examples that way you can easily remove columns using migration. let’s see the below example that will help you.
1) Remove the Column using Migration
2) Remove Multiple Column using Migration
3) Remove Column If Exists using Migration
Remove Column using Migration
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangeslugsTableColumn extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('slugs', function (Blueprint $table) {
$table->dropColumn('orgs');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}Remove Multiple Column using Migration
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangePostsTableColumn extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('slugs', function (Blueprint $table) {
$table->dropColumn(['orgs', 'title']);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}Remove Column If Exists using Migration
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangeslugsTableColumn extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
if (Schema::hasColumn('slugs', 'orgs')){
Schema::table('slugs', function (Blueprint $table) {
$table->dropColumn('slug_id');
});
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}I hope This will be helpful…!!!
