DB_PREFIX is not recognized in migration dropColumn and dropForeign

[yespbs]

• Laravel Version: all. tested upto 7.13
• PHP Version: all. tested upto 7.4
• Database Driver & Version: mysql all, tested upto 8

Description:

DB_PREFIX is not recognized in migration dropColumn and dropForeign. As prefix creates foreign keys with prefix itself, while removing, it fails to associate the same and halts. To by pass, each case table name must be wrapped with env('DB_PREFIX')

Steps To Reproduce:

1. Add something in .env DB_PREFIX=sgd_
2. Add a migration with foreign key
3. Try to migrate:rollback

[armancodes]

I tried to create the tables using the DB_PREFIX=foo in the .env file but it didn't work.

Here's the reason:
As I can see in the config/database.php file database connections are not using the env('DB_PREFIX') instead they used an empty string:

You can just change the value of their prefix to something else to see if this works. For me, it worked as expected.

[yespbs]

@armancodes
By default prefix is not enabled, you can enable by adding the env

'prefix' => env('DB_PREFIX', ''),

which works, all normal create, drop works except for foreign keys added/dropped in a migration.

This issue is related to dropColumn and dropForeign.

If you use dropColumn with array wrap like dropColumn (['column_name']) it drops column as well foreign keys associated unless you use DB_PREFIX

[armancodes]

Can you share the code and the error?

[yespbs]

some how old code was causing trouble but fresh install solved that
please close

Thanks for tip

[driesvints]

Moving to discussions.