Create table in SQLite only if it doesn't exist already

sqlite create-table database-table
user461112 picture user461112 · Nov 4, 2010 · Viewed 209.3k times · Source

I want to create a table in a SQLite database only if doesn't exist already. Is there any way to do this? I don't want to drop the table if it exists, only create it if it doesn't.

Answer

David Wolever picture David Wolever · Nov 4, 2010

From http://www.sqlite.org/lang_createtable.html:

CREATE TABLE IF NOT EXISTS some_table (id INTEGER PRIMARY KEY AUTOINCREMENT, ...);

Related questions

android sqlite CREATE TABLE IF NOT EXISTS

Having a little problem with creating new tables. When I use the CREATE TABLE command my new tables form as they should, but when I exit the activity the app crashes and I get a TABLE ALREADY EXISTS in the …

Read More
SQLite composite key (2 foreign keys) Link table

I've read the rather cool styled BNF grammar for the SQLite create table statement found here: http://www.sqlite.org/lang_createtable.html I was wondering how I'd go about creating a link table between these I have one table, …

Read More
SQLite Foreign Key

I'm following the instructions from the SQLite documentation at http://www.sqlite.org/foreignkeys.html however my attempt to add a foreign key is failing. Here are my create statements: CREATE TABLE checklist ( _id INTEGER PRIMARY KEY AUTOINCREMENT, checklist_title …

Read More