Laravel drop foreign key

Laravel foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
});

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

Laravel drop foreign key

// Primary table name, from Schema::table(<table>)
// Primary column, from $table->foreign(<column>)
$table->dropForeign('<table>_<column>_foreign');

Source: stackoverflow.com

Table drop foreign php laravel

 public function down()
 {
   Schema::table('tarefas', function (Blueprint $table) {
     $table->dropForeign('tarefas_user_id_foreign');

     $table->dropColumn('user_id');
   });
 }

Similar codes

7 votes231 views5 answers
Laravel slug
PHP Laravel
0 vote230 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
5 votes300 views3 answers
Display all errors in blade laravel
PHP Laravel
0 vote216 views1 answer
$this- attribute laravel
PHP Laravel
0 vote305 views1 answer
Laravel count data wise
PHP Laravel
33 votes318 views6 answers
Migrate specific migration laravel
PHP Laravel
1 vote216 views1 answer
Model json laravel accessor to convert to array
PHP Laravel
21 votes260 views2 answers
Long text in laravel migration
PHP Laravel
28 votes321 views12 answers
Laravel middleware
PHP Laravel
0 vote228 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel