/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

1 vote322 views1 answer
Laravel profile migration tool
PHP Laravel
2 votes218 views1 answer
Laravel asset
PHP Laravel
10 votes246 views2 answers
Array to string conversion in laravel controller
PHP Laravel
0 vote264 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel
0 vote229 views1 answer
Verta sample jalali laravel problem return object
PHP Laravel
24 votes218 views6 answers
Validation error message in laravel
PHP Laravel
0 vote232 views1 answer
Laravel blade array seearch select box
PHP Laravel
0 vote242 views1 answer
Laravel timestamps on pivot table
PHP Laravel
0 vote243 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
2 votes227 views3 answers
Php laravel dump
PHP Laravel