Flyway history table
testbg2020
Posts: 1 New member
Hi, I accidentally created many .sql files and ran them. I don't want to rollback. Can I simply delete the rows from the flyway history table? If I try to delete, I get the below error.
Object dbname.schema-name.table-name does not exist or not authorized.
Object dbname.schema-name.table-name does not exist or not authorized.
Answers
The history table is purely for keeping a record of what migrations you've applied: https://documentation.red-gate.com/fd/migrations-184127470.html#schema-history-table
What is the desired outcome here?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?