/PHP/Laravel/Remove foreign key constraint laravel

Remove foreign key constraint laravel

Laravel remove foreign key

$table->dropForeign('posts_user_id_foreign');

Source: laravel.com

Larael drop foreign key

Schema::table('posts', function (Blueprint $table) {
	$table->dropForeign(['category_id']);
});

Disable foreign key laravel

//...
class ClearOldOauthRelations extends Migration
{
    public function up()
    {
        Schema::disableForeignKeyConstraints();
        // drop foreign keys
        Schema::table('oauth_access_tokens', function (BluePrint $table) {
            $table->dropForeign('oauth_access_tokens_session_id_foreign');
        });
        //...
        Schema::enableForeignKeyConstraints();
    }
    //...
}

Source: stackoverflow.com

Remove foreign key constraint laravel

Schema::table('table_name', function (Blueprint $table) {
    $table->dropForeign(['foreign_key']);
    $table->dropColumn('column_key');
});

PS: usually foreign_key = column_key

ex: 

Schema::table('despatch_discrepancies', function (Blueprint $table) {
    $table->dropForeign(['pick_detail_id']);
    $table->dropColumn('pick_detail_id');
});

Source: stackoverflow.com

Laravel migration drop foreign keys

$table->dropIndex(['state']); // Drops index 'geo_state_index'

Drop foreign key laravel

Schema::table('admins', function (Blueprint $table) {    $table->dropForeign('admins_post_id_foreign');    $table->dropColumn('post_id');});

Source: itsolutionstuff.com

Similar codes

3 votes172 views2 answers
How to check null and empty array in laravel 8
PHP Laravel
7 votes183 views3 answers
Call table name in model laravel
PHP Laravel
4 votes207 views5 answers
Laravel with and where
PHP Laravel
0 vote185 views2 answers
Laravel insert with id
PHP Laravel
0 vote189 views1 answer
Remove controller cache laravel
PHP Laravel
18 votes183 views6 answers
Install laravel auth
PHP Laravel
31 votes170 views5 answers
How to make db seeder in laravel
PHP Laravel
7 votes176 views2 answers
Laravel unique multiple columns
PHP Laravel
0 vote220 views1 answer
Laravel array cast
PHP Laravel
1 vote183 views1 answer
Increment single column laravel
PHP Laravel