[BUG]: Migrations dropping tables does not consider dependents

[cybercoder-naj]

What version of drizzle-orm are you using?

0.31.2

What version of drizzle-kit are you using?

0.22.8

Describe the Bug

The previous schema had 3 tables: users, user_auth, user_session. user_session.userId was a foreign key to user_auth.id. My actions were:

1. delete the user_auth table.
2. user_session.userId was a foreign key to users.id.

The migrations were:

1. DROP TABLE user_auth;
2. Altering the constraint of user_session.userId.

However, the 1st command errored since user_session depended on user_auth.

Expected behavior

Run proper migrations considering dependents with foreign keys.

Environment & setup

Linux, bun 1.1.17.

[L-Mario564]

@cybercoder-naj What DB are you using?

[cybercoder-naj]

I am using PostgreSQL v16.