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?


Reply via email to