/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 vote267 views1 answer
Vscode open php tag autocomplete
PHP
0 vote293 views1 answer
Magento 2 get connection
PHP
2 votes280 views1 answer
Php string take part
PHP
2 votes267 views1 answer
Laravel commands to refresh env file
PHP
4 votes313 views1 answer
Uuid package generator laravel
PHP Laravel
0 vote269 views1 answer
Haseeb php code
PHP
1 vote337 views1 answer
Laravel start que listener
PHP Laravel
1 vote321 views1 answer
Laravel select all except some columns
PHP Laravel
1 vote272 views1 answer
Program logic for second largest number in an array in php
PHP
0 vote275 views1 answer
Windows 10 command line turn off wifi
PHP