So with that train of thought. I removed DBeaver from the process. I delete the local database, and
So with that train of thought. I removed DBeaver from the process. I delete the local database, and rebuilt it using the same script locally using wrangler only.
Then tried to run the database build script a 2nd time using just wrangler and got the same no such table error.
If I manually drop the tables in the same order as the script attempts, with no 'If Exists' then it works.
If I try to drop the tables in the same order with If Exists is shows the error.
So not sure if that makes sense, but yeah. I wouldn't expect to see that error.
Then tried to run the database build script a 2nd time using just wrangler and got the same no such table error.
If I manually drop the tables in the same order as the script attempts, with no 'If Exists' then it works.
If I try to drop the tables in the same order with If Exists is shows the error.
So not sure if that makes sense, but yeah. I wouldn't expect to see that error.
