Noob question about DROP TABLE ordering

Hello!

I'm about to drop my first table with Drizzle, and I noticed the SQL file looks like this:

DROP TABLE "merlin_schools";--> statement-breakpoint
ALTER TABLE "merlin_auth_user" DROP CONSTRAINT "merlin_auth_user_school_merlin_schools_id_fk";
--> statement-breakpoint
ALTER TABLE "merlin_groups" DROP CONSTRAINT "merlin_groups_school_id_merlin_schools_id_fk";
--> statement-breakpoint
ALTER TABLE "merlin_auth_user" DROP COLUMN IF EXISTS "school";--> statement-breakpoint
ALTER TABLE "merlin_groups" DROP COLUMN IF EXISTS "school_id";

DROP TABLE "merlin_schools";--> statement-breakpoint
ALTER TABLE "merlin_auth_user" DROP CONSTRAINT "merlin_auth_user_school_merlin_schools_id_fk";
--> statement-breakpoint
ALTER TABLE "merlin_groups" DROP CONSTRAINT "merlin_groups_school_id_merlin_schools_id_fk";
--> statement-breakpoint
ALTER TABLE "merlin_auth_user" DROP COLUMN IF EXISTS "school";--> statement-breakpoint
ALTER TABLE "merlin_groups" DROP COLUMN IF EXISTS "school_id";

won't dropping the table first cause issues with the FK contraints?

benjickOP•6/1/24, 1:28 PM

Yeah, got this error:

error: cannot drop table merlin_schools because other objects depend on it

juanvilladev•6/2/24, 6:59 PM

@benjick you figure this out? we can't drop a table either because of this. I'm pretty sure drizzle-kit should've deleted all references to the table first THEN dropped the table...

Jjuanvilladev @benjick you figure this out? we can't drop a table either because of this. I'm ...

benjickOP•6/3/24, 8:01 AM

Yeah I just moved the DROP statement to the end of the file manually