Using migrations to delete table with foreign key

Question

Im trying to roll back my migrations.

My migrations file uses foreign keys like so

$table->foreign('user_one')->references('id')->on('users'); $table->foreign('user_two')->references('id')->on('users'); 

My down() function is like so

public function down() {     Schema::drop('pm_convo');     Schema::drop('pm_convo_replys'); } 

When i run my migrate command

php artisan migrate:refresh --seed --env=local 

I am getting the following error

SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails (SQL: drop table `pm_convo`)  

Im not exactly sure what to do to fix this.

Edit:

I have tried: $table->dropForeign('pm_convo_user_one_foreign');

But im getting errors with that as well

Answer 1

I think this is a better way to do it:

public function down() {     DB::statement('SET FOREIGN_KEY_CHECKS = 0');     Schema::dropIfExists('tableName');     DB::statement('SET FOREIGN_KEY_CHECKS = 1'); }