Reset "resolved migrations"?

[surfingreg]

So I did an sqlx migrate add create_dumb_table. Then I changed my mind and manually deleted the .sql file it generated. Now when I run sqlx migrate run I get "error: migration 20220726152059 was previously applied but is missing in the resolved migrations".

How do I remove all memory of that migration? Where are migrations persisted if the migrations/*.sql file no longer exists?

Thanks!

[StrayLittlePunk]

I try below command can work
enter your DATABASE_URL point to database , and execute below command

drop table _sqlx_migrations;