/PHP/Laravel/Laravel check if table has column

Laravel check if table has column

Laravel drop column if exists

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

Table has column laravel

Schema::hasColumn('users', 'email') // laravel

Laravel migration check if table has column

// You may check for the existence of a table or column
// using the hasTable and hasColumn methods:

if (Schema::hasTable('users')) {
    // The "users" table exists...
}

if (Schema::hasColumn('users', 'email')) {
    // The "users" table exists and has an "email" column...
}

Source: laravel.com

Laravel check if table has column

if (Schema::hasTable('users')) {
    // The "users" table exists...
}

if (Schema::hasColumn('users', 'email')) {
    // The "users" table exists and has an "email" column...
}

Source: laravel.com

Similar codes

0 vote158 views1 answer
Razorpay refund laravel
PHP Laravel
0 vote163 views1 answer
Import local js file laravel
PHP Laravel
0 vote151 views2 answers
Laravel pagination vuetify
PHP Laravel
18 votes156 views6 answers
Laravel log error
PHP Laravel
0 vote150 views1 answer
Laravel faker generate country code
PHP Laravel
19 votes150 views6 answers
Laravel Route Group
PHP Laravel
0 vote162 views1 answer
Laravel enable extensions on Ubuntu
PHP Laravel
1 vote161 views1 answer
Laravel 6 tymon/jwt-auth
PHP Laravel
0 vote156 views1 answer
Laravel model query limit
PHP Laravel
2 votes184 views1 answer
Laravel difference between current time and created time
PHP Laravel