/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 vote383 views2 answers
Laravel middleware in constructor
PHP Laravel
2 votes365 views2 answers
How to add data to the request object in laravel
PHP Laravel
0 vote325 views1 answer
What is errore Personal access client not found. Please create one in laravel
PHP Laravel
1 vote333 views1 answer
Laravel carbon time format AM PM
PHP Laravel
0 vote360 views1 answer
Check null in laravel blade
PHP Laravel
0 vote322 views1 answer
Show images laravel 8 showJobImage($filename)
PHP Laravel
-1 vote351 views2 answers
Laravel eloquent update multiple records
PHP Laravel
8 votes347 views1 answer
Add sucssess message laravel
PHP Laravel
8 votes325 views3 answers
Force delete soft delete laravel
PHP Laravel
6 votes333 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel