I have question about python and sqlite3. I want to drop a table from within Python. The command <pre class="prettyprint"><code>cur.execute('drop table if exists tab1') </code></pre> Does not work. <pre class="prettyprint"><code>cur.executescript('drop table if exists tab1;') </code></pre> does the job. The execute method allows the creation of tables. However, it won't drop them? Is there a reason for this?

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

drop table in python with sqlite3

Tags:

python

sqlite

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?

438

asked Jan 13 '10 20:01

nwhsvc

1 Answers

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.

173