drop table in python with sqlite3

Question

I have question about python and sqlite3. I want to drop a table from within Python. The command

cur.execute('drop table if exists tab1')

Does not work.

cur.executescript('drop table if exists tab1;')

does the job.

The execute method allows the creation of tables. However, it won't drop them? Is there a reason for this?

Travis Bradshaw · Accepted Answer · 2010-01-13 20:43:49Z

15

The cur.executescript command issues a COMMIT before running the provided script. Additionally a CREATE executes a COMMIT intrinsically. Perhaps you have an open transaction that needs committed before your changes take place.

answered Jan 13, 2010 at 20:43

Travis Bradshaw

4,3403 gold badges24 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

http8086 Over a year ago

What if drop table by sqlite3.connect('disk_sqlite3').cursor().execute() works while sqlite3.connect(':memory:').cursor().execute() does not?

Collectives™ on Stack Overflow

drop table in python with sqlite3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related