/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

7 votes155 views4 answers
$errors show this error in laravel
PHP Laravel
8 votes159 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel
0 vote168 views1 answer
Laravel 8 Auth Scaffolding using Inertia Jetstream
PHP Laravel
1 vote161 views3 answers
Laravel multiple paginate
PHP Laravel
0 vote157 views10 answers
Event handler with worker laravel
PHP Laravel
2 votes158 views3 answers
Laravel check if field has changed
PHP Laravel
0 vote187 views1 answer
Encode in laravel api
PHP Laravel
5 votes180 views1 answer
Laravel get random row
PHP Laravel
1 vote166 views1 answer
Laravel eloquent get 10 records
PHP Laravel
0 vote158 views1 answer
Raw query in laravel with parameters
PHP Laravel