laravel cannot drop foreign key code example

Example 1: laravel remove foreign key

$table->dropForeign('posts_user_id_foreign');

Example 2: cannot add foreign key constraint laravel

Add it in two steps, and its good to make it unsigned too:
public function up()
{
    Schema::create('priorities', function($table) {
        $table->increments('id', true);
        $table->integer('user_id')->unsigned();
        $table->foreign('user_id')->references('id')->on('users');
        $table->string('priority_name');
        $table->smallInteger('rank');
        $table->text('class');
        $table->timestamps('timecreated');
    });
}

if still same error try removing unsigned() from the above code

Tags:

Sql Example