Hi, I am using stable web2py, with sqlite db and trying to drop a table. In the shell, I connect to the db, then
In [6] : print db._uri sqlite://storage.sqlite In [7] : print db._dbname sqlite In [8] : print db.tables ['auth_user', 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', 'auth_cas', 'sale', 'sales'] In [9] : db.sale.drop() In [10] : print db.tables ['auth_user', 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', 'auth_cas', 'sale', 'sales'] In [11] : db.sale.drop() In [12] : print db.tables ['auth_user', 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', 'auth_cas', 'sale', 'sales'] In [13] : db.commit() In [14] : print db.tables ['auth_user', 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', 'auth_cas', 'sale', 'sales'] How do I get rid of the table "sale" but keep "sales"? The table persists after I end the web2py session. thanks, Margaret --
