DekGenius.com
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']);
});
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");
© 2022 Copyright:
DekGenius.com