/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 vote161 views1 answer
Laravel sanctum axios Unauthenticated
PHP Laravel
0 vote158 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
1 vote226 views1 answer
Supervisor configuration for laravel queue
PHP Laravel
8 votes195 views2 answers
Laravel drop multiple columns
PHP Laravel
2 votes146 views1 answer
Laravel force login by id
PHP Laravel
18 votes187 views6 answers
Laravel model
PHP Laravel
12 votes165 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
5 votes155 views3 answers
Laravel display error message
PHP Laravel
0 vote159 views1 answer
Laravel repository update multiple row
PHP Laravel
0 vote164 views1 answer
Laravel interview questions
PHP Laravel