I called define_table to create a table "product". This worked fine.
Then I called executesql("DROP TABLE PRODUCT"). The product table
appears to have been dropped from the database. However when I run the
application again it fails in the model in at the define_table line
with "OperationalError: no such table: product"
I am able to define_table("product2".....) and db.product2.drop() and
define_table("product2"....) again. However as soon as I use the
manual SQL DROP it seems that I cannot use that table name again in
the database.
Is there somewhere the table names are stored? Is it possible to
cleanly delete tables outside the DAL using DROP TABLE?