/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

62 votes309 views6 answers
Clear cache laravel
PHP Laravel
0 vote173 views1 answer
Laravel update single field
PHP Laravel
0 vote180 views1 answer
Laravel Can't write image data to path Image::make($image)->resize
PHP Laravel
0 vote152 views1 answer
Laravel Testing send raw data in GET method
PHP Laravel
1 vote156 views1 answer
Types of looping directives in laravel
PHP Laravel
2 votes159 views3 answers
Laravel fortify
PHP Laravel
1 vote152 views1 answer
Scedule work laravel
PHP Laravel
0 vote139 views2 answers
Laravel blade components
PHP Laravel
13 votes164 views6 answers
Laravel migration change column type
PHP Laravel
0 vote154 views1 answer
Old function use in checkbox selected in laravel blade
PHP Laravel