How do I delete the _prisma_migrations table?

I'm using prisma and deploying it to fly.io. I deleted the migrations in the prisma/migrations folder. When I run prisma migrate deploy it still applies the migrations that I deleted. How do I delete the _prisma_migrations table in order to completely get rid of the deleted migrations?

Solution

Use the sqlite3 terminal. Open the terminal by using the command sqlite3 Then use the DROP TABLE _prisma_migrations; command

Prisma openssl version issue
Prisma how can I update only some of the models fields in update()
TypeError while running a database seeding script in Next.js, Prisma ORM
get full type on prisma client
Reason: `object` ("[object Date]") cannot be serialized as JSON. Please only return JSON serializable data types
"Next.js TypeScript error: 'param_type.params' incompatible with 'ParamCheck<RouteContext>' during build"
prisma - getting environment variable not found error message when running graphql query
Fetching Next.js API Route in the app directory gives 404 Not Found
PrismaClientValidationError Invalid `prisma.ticket.create()` invocation
How can I put my variable inside Axios and send it to my database?
How do I return an image from my sveltekit api to the client?
How to get Prisma client to generate relationship types
How to upsert new record in Prisma without an ID?
@prisma/client did not initialize yet. Please run "prisma generate" and try to import it again
The right way to create an auto increment ID on Prisma using mongodb
next-auth credentials provider authorize type error
Prisma find many and count in one request
Seeding with prisma nested create with one-to-one relation
prisma Error: p1001: Can't reach database server at `db.xocheossqzkirwnhzxxm.supabase.co`:`5432`
Filter by ObjectId with equals operator in $search pipeline stage does not work
TypeError: The "payload" argument must be of type object. Received null
Using a prisma query with callback seems to ignore try/catch blocks (Node)
How can I insert a dynamically-chosen raw SQL clause when using prisma.$queryRaw as a template literal tag?
the created_at search in prisma aggregateRow mongodb does not work
Prisma query engine not found on mac M1
Prisma: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`
Unknown binaryTarget debian-openssl-3.0.x and no custom binaries were provided error Command failed with exit code 1
When use two argument or more with where get error
Apply Prisma Migrations to Multiple Environments with Kubernetes
prisma - make a field equal to another when it is created