PHP

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();
    }
    //...
}

larael drop foreign key

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

laravel migration remove constraint

// There are two ways to handle this:

// 1.	You can simply pass the column name wrapped in an array
//		and let laravel sort out the rest:
Schema::table('users', function (Blueprint $table) {
  $table->dropUnique(['email']);
  // $table->dropIndex(['email']); --> this pattern also works for other constraints/indexes like this
});

// 2.	You can remember the way laravel formats index names ([TABLE_NAME]_[COLUMN_NAME]_unique),
// 		and pass that as a string:
Schema::table('users', function (Blueprint $table) {
	$table->dropUnique('users_email_unique');
});

table drop foreign php laravel

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

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

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');
});

laravel remove foreign key

$table->dropForeign('posts_user_id_foreign');

laravel drop foreign key

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

laravel drop foreign column

// Searched, laravel drop foreign column
Schema::table('users', function (Blueprint $table) {
    $table->dropColumn(['votes', 'avatar', 'location']);
});

laravel migration drop foreign keys

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

laravel migration drop foreign keys

$table->dropPrimary('users_id_primary');

delete all rows in table laravel foreign key

DB::statement("SET foreign_key_checks=0");
Model::truncate();
DB::statement("SET foreign_key_checks=1");