/PHP/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

0 vote187 views1 answer
Find the next 7 date data in laravel eloquent
PHP Laravel
1 vote154 views1 answer
Change background color php
PHP
10 votes123 views4 answers
Error logs wp
PHP
4 votes133 views1 answer
Password match laravel
PHP
6 votes152 views3 answers
Disable foreign key laravel
PHP Laravel
9 votes120 views6 answers
Laravel drop foreign key
PHP
0 vote128 views1 answer
Copy file from one directory to another Laravel
PHP
0 vote150 views1 answer
Acf get image id sub_field
PHP
1 vote156 views1 answer
Laravel get first letter of each word
PHP
3 votes125 views1 answer
Laravel check if array is empty
PHP