if you don't care about the data, just use YourTable.dropTable()
i.e.
>>> from sqlobject import *
>>> class YourTable(SQLObject):
... aField = StringCol()
...
>>> YourTable._connection = connectionForURI('sqlite:/:memory:')
>>> YourTable.createTable()
[]
>>> list(YourTable.select())
[]
>>> YourTable.dropTable()
>>> list(YourTable.select())
Traceback (most recent call last):
...
pysqlite2.dbapi2.OperationalError: no such table: your_table
>>>
On 7/7/06, Emily Fortuna <[EMAIL PROTECTED]> wrote:
> Hello everyone,
> How can you delete an entire table (so that you can set up a new one
> with different columns -- I'm using SQLite)? I've been searching all
> over the web and can't seem to find it.
> Emily
>
>
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
