/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

4 votes172 views2 answers
Numbric validate laravel
PHP Laravel
1 vote189 views2 answers
Insert batch in laravel
PHP Laravel
15 votes195 views1 answer
Laravel composer install ignore
PHP Laravel
1 vote290 views2 answers
Get current month laravel
PHP Laravel
18 votes181 views4 answers
Protected table laravel
PHP Laravel
5 votes178 views2 answers
Remove “/public” from Laravel route
PHP Laravel
0 vote172 views1 answer
Running laravel project in mobile phone
PHP Laravel
12 votes171 views3 answers
Laravel db::query update
PHP Laravel
7 votes160 views5 answers
Laravel foreach loop index in controller
PHP Laravel
10 votes177 views2 answers
Laravel 8 try catch
PHP Laravel