I have a database, which appears to be ok:
sqlite> pragma integrity_check;
integrity_check
---------------
ok
And `pragma foreign_key_check` also returns no errors, yet I am unable to drop a table due to some schema issue:
sqlite> drop table countries;
Error: no such table: main.Service_Catalog
I'll be able to trace the various schema statements to work out what my issue is[1] so I'm not asking for help. But perhaps there is a different pragma that reports on such conditions, and in more detail?
I don't know how I got the current schema (lots of fast-paced development) but it would also be nice if SQLite prevented me from creating it.
[1] Unfortunately I am unable to share the schema publically.