/PHP/Laravel/Laravel migration remove unique constraint

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

37 votes381 views6 answers
Laravel create or update
PHP Laravel
0 vote342 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
0 vote476 views1 answer
Script to create AdminLTE in a Laravel project
PHP Laravel
8 votes342 views3 answers
Create migration with model laravel 8
PHP Laravel
2 votes334 views1 answer
How get all files name in one folder in laravel
PHP Laravel
3 votes338 views2 answers
Laravel required if another field has value
PHP Laravel
0 vote351 views1 answer
Laravel migration type to store html
PHP Laravel
2 votes347 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel
1 vote361 views1 answer
Use app name in laravel blade
PHP Laravel
0 vote294 views1 answer
Laravel count soft delete data
PHP Laravel