How to drop a sqlite3 database in python?

Question

I am testing some database manipulation with sqlite3 in python, but for some reason I am not able to replicate some commands from SQL in sqlite3. In my case I have a function that tests a query and it creates a sample database with some tables and data. However, I am not able to drop the database using sqlite and rather have to use the following code:

import os
os.remove(databaseName)

Would sqlite3 have any command for dropping a database, or even creating a temporary one?

score 16 · Accepted Answer · 2016-04-03 02:08:32Z

16

There is no command in sqlite to drop a database, as the database is saved in a file. To drop it you would just delete the file.

You can however create in-memory databases by using :memory: as the filename: conn = sqlite3.connect(':memory:'). See https://www.sqlite.org/inmemorydb.html

edited Apr 3, 2016 at 2:08

answered Apr 3, 2016 at 2:00

user1833590

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

1 Comment

Kiruahxh Over a year ago

However the database may reference temporary files.

Collectives™ on Stack Overflow

How to drop a sqlite3 database in python?

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