/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 vote265 views1 answer
Laravel unique column except self
PHP Laravel
0 vote236 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel
6 votes271 views2 answers
Findorfail laravel
PHP Laravel
0 vote268 views1 answer
Laravel create table with model command line
PHP Laravel
0 vote257 views1 answer
Group where conditions in laravel
PHP Laravel
0 vote250 views2 answers
Laravel pagination vuetify
PHP Laravel
0 vote240 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
0 vote268 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
0 vote269 views1 answer
Laravel append parameter to links
PHP Laravel
2 votes255 views2 answers
Laravel migration add unique column
PHP Laravel