Breaking News: Grepper is joining You.com. Read the official announcement!

laravel migration remove unique constraint

Add Answer

PDXfoster answered on June 29, 2021 Popularity 9/10 Helpfulness 7/10

answer laravel migration remove unique constraint

related laravel migration remove unique constraint

related laravel migration remove unique

laravel migration remove unique constraint

Comment

// There are two ways to handle this:

// 1.	You can simply pass the column name wrapped in an array
//		and let laravel sort out the rest:
Schema::table('users', function (Blueprint $table) {
  $table->dropUnique(['email']);
  // $table->dropIndex(['email']); --> this pattern also works for other constraints/indexes like this
});

// 2.	You can remember the way laravel formats index names ([TABLE_NAME]_[COLUMN_NAME]_unique),
// 		and pass that as a string:
Schema::table('users', function (Blueprint $table) {
	$table->dropUnique('users_email_unique');
});

Popularity 9/10 Helpfulness 7/10 Language php

Source: stackoverflow.com

Tags: laravel migration php unique-constraint

Link to this answer
Share Copy Link

Contributed on Nov 04 2022

PDXfoster

0 Answers Avg Quality 2/10

Closely Related Answers

laravel migration remove unique constraint

Comment

/** To drop an index you must specify the index's name. 
Laravel assigns a reasonable name to the indexes by default. 
Simply concatenate the table name, the names of the column in the index, 
and the index type **/

// Format of unique key tableName_column_unique
$table->dropUnique('users_email_unique');

Popularity 10/10 Helpfulness 8/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jun 29 2021

Smiling Starling

0 Answers Avg Quality 2/10

laravel migration remove unique

Comment

//The UNique need be a constraint name
// This name has this format:
// [TABLE_NAME]_[COLUMN_NAME]_unique
// For 'users' table and 'user_code' column, whe get the name:
// users_user_code_unique
$table->dropUnique('users_user_code_unique');

//The inverst is 
$table->unique('user_code');

Popularity 9/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Sep 14 2021

Tiago F2

0 Answers Avg Quality 2/10

laravel migration remove unique constraint

Contents

More Related Answers

laravel migration remove unique constraint

Closely Related Answers

laravel migration remove unique constraint

laravel migration remove unique

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.