/PHP/Laravel/Laravel migration remove unique

Laravel migration remove unique

Laravel migration remove unique constraint

/** 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');

Laravel migration remove unique

//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');

Similar codes

0 vote190 views1 answer
Laravel get all users except role spatie
PHP Laravel
1 vote200 views1 answer
Clear cache using laravel controller
PHP Laravel
1 vote201 views2 answers
Use multiple database in laravel
PHP Laravel
0 vote217 views1 answer
Laravel creating event get data
PHP Laravel
3 votes315 views2 answers
Laravel disable csrf token
PHP Laravel
12 votes206 views6 answers
Set session data in laravel
PHP Laravel
1 vote216 views2 answers
Laravel query builder sum
PHP Laravel
4 votes205 views3 answers
Laravel use config
PHP Laravel
0 vote208 views1 answer
Laravel eloquent order by alphabetical order
PHP Laravel
0 vote206 views1 answer
Copy file from one directory to another Laravel
PHP Laravel