/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

1 vote274 views1 answer
What is app_env in laravel
PHP Laravel
11 votes280 views2 answers
Laravel mass update relationship
PHP Laravel
38 votes240 views6 answers
Laravel foreign key
PHP Laravel
0 vote260 views1 answer
Laravel post request search query
PHP Laravel
5 votes221 views6 answers
Laravel sort collection
PHP Laravel
1 vote238 views1 answer
Date format in laravel month name day name
PHP Laravel
5 votes257 views4 answers
Update column type laravel migration
PHP Laravel
0 vote258 views2 answers
Laravel collection intersect
PHP Laravel
0 vote194 views1 answer
Appserviceprovider laravel share common settings for all controllers
PHP Laravel
3 votes220 views1 answer
Laravel middleware route
PHP Laravel