Check If a Column Exists in Laravel Migration File

Question

Already I have a table name table_one. Now I want to add two more columns to it. Everything works fine so far. But in my method, I want to check a column exists or not in my table like dropIfExists('table').

/**  * Run the migrations.  *  * @return void  */ public function up() {     Schema::table('table_one', function (Blueprint $table) {         $table->string('column_one')->nullable();         $table->string('column_two')->nullable();     }); }  /**  * Reverse the migrations.  *  * @return void  */ public function down() {     Schema::table('table_one', function (Blueprint $table) {         // in here i want to check column_one and column_two exists or not         $table->dropColumn('column_one');         $table->dropColumn('column_two');     }); } 

Answer 1

You need something just like this

  public function down()     {         if (Schema::hasColumn('users', 'phone'))         {             Schema::table('users', function (Blueprint $table)             {                 $table->dropColumn('phone');             });         }     } 

Answer 2

You could make your own 'dropColumnIfExists()' function that checks the column existence then drop it:

function myDropColumnIfExists($myTable, $column) {     if (Schema::hasColumn($myTable, $column)) //check the column     {         Schema::table($myTable, function (Blueprint $table)         {             $table->dropColumn($column); //drop it         });     }  } 

And use it on 'down()' function like this:

public function down() {     myDropColumnIfExists('table_one', 'column_two');     myDropColumnIfExists('table_one', 'column_one'); }