/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

5 votes272 views2 answers
Laravel 8 routes namespace
PHP Laravel
0 vote235 views1 answer
Get the last saved row in a table laravel
PHP Laravel
0 vote273 views1 answer
Laravel eloquent only today
PHP Laravel
50 votes325 views6 answers
Laravel add column to table
PHP Laravel
0 vote280 views1 answer
Laravelstart project
PHP Laravel
29 votes266 views3 answers
Laravel clear page cache
PHP Laravel
11 votes238 views2 answers
Laravel log level
PHP Laravel
0 vote277 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
2 votes270 views2 answers
Laravel get file in public folder
PHP Laravel
0 vote255 views1 answer
Laravel migration folder
PHP Laravel