It works for me. web2py 2.3.2 src on windows.
On Saturday, January 19, 2013 5:48:49 PM UTC-5, greaneym wrote: > > 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 > > --
