DEV Community

loading...

How to remove a column from Laravel table using migration

Osman Forhad
👨‍💻Mobile & Web Application Developer (ReactNative, Nodejs, MongoDB, React, Laravel, Mysql)
・1 min read

I was working with Laravel framework and i create a laravel migration table and working with it but after some times i need to remove a column from my table and its should do using laravel migration. for that what was the process i deed. i want to share may knowledge with you.

for that the very first step was. i opened my terminal and navigate to project directory after that i was run below command on my terminal:

php artisan make:migration remove_categorrystatus_from_categories --table=categories

this command create a migration file for me and then i open this file and wrote my migration schema to remove a column from my database table. when i open the fle i saw there two function one is public function up and another is public function down.

To remove a column i updated those functions which is like bellow:
//the up function is
public function up()
{
Schema::table('categories', function (Blueprint $table) {
$table->dropColumn('categorrystatus');
});
}
//the down function is
public function down()
{
Schema::table('categories', function (Blueprint $table) {
$table->dropColumn('categorrystatus');
});
}

an then i go to my terminal and run below command:

php artisan migrate

which was remove the categorrystatus column from my catgories table
.
that's it. all are done
.
Happy Coding.
osman forhad

Discussion (0)