/PHP/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

0 vote144 views1 answer
Exclude row from clooection laravel
PHP
0 vote160 views1 answer
If name value contains space in php
PHP
0 vote224 views1 answer
Mkdir permission denied php
PHP
0 vote158 views1 answer
Set a minimum character value in php
PHP
0 vote157 views1 answer
Laravel create text file
PHP
0 vote184 views1 answer
Update query in codeigniter using where condition
PHP CodeIgniter
13 votes226 views6 answers
Laravel api routes
PHP Laravel
13 votes150 views4 answers
Laravel make migration update table
PHP
18 votes157 views3 answers
Php pop off the first character of string
PHP
2 votes181 views2 answers
Get all sort by laravel
PHP Laravel