Ad

Cant Drop Foreign Key On Existing Table?

- 1 answer

I'm trying to drop the foreign key to an existing table using migration but it throws an error as "Syntax error or access violation:1091 cant DROP consultant_id :check that column/key exists". Can you please help with it?

Ad

Answer

First of all, you have to drop Foreign constraint.

public function up() {
       Schema::table('table_name', function (Blueprint $table) {
            $table->dropForeign('table_name_consultant_id_foreign');
            $table->dropColumn('consultant_id');
        });

    }
Ad
source: stackoverflow.com
Ad