Removing unique constraint from a column using Laravel migrations

In this tutorial, we will see how to remove unique constraint from a column using laravel migrations. You can easily remove unique constraint from a column using laravel migrations.

Given below are 2 examples showing how to remove unique constraint from a column using laravel migrations.

Example-1:

class AlterEmailToUsers extends Migration
{
/**
 * Run the migrations.
 *
 * @return void
 */
public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->string('email')->unique(false)->nullable()->change();
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('users', function (Blueprint $table) {
       $table->string('email')->nullable(false)->unique()->change();
    });
}

Example-2:

class AlterEmailToUsers extends Migration
{
/**
 * Run the migrations.
 *
 * @return void
 */
public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->dropUnique('users_email_unique');
    });
}

I hope this example helps you.