sqlite - how to check if table exists before completing inserts? [duplicate]

Question

What is the best SQL for a SQLite database to effectively do:

If Database Table Exists then - create table - insert row - insert row (i.e. for startup data) end

answered here: stackoverflow.com/questions/1601151/…

krystan honour
– krystan honour

2012-04-25 09:07:29 +00:00
Commented Apr 25, 2012 at 9:07 — krystan honour
– krystan honour, Commented Apr 25, 2012 at 9:07

Yaqub Ahmad · Accepted Answer · 2012-04-25 09:40:27Z

31

To check that your table exists or not, you can use:

SELECT * FROM sqlite_master WHERE name ='myTable' and type='table';

answered Apr 25, 2012 at 9:40

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

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

2 Comments

Greg Over a year ago

ok - so you think it best to keep the inserts as separate sql statements I assume? thanks

PatchyFog Over a year ago

For TEMP tables, you must look at sqlite_temp_master.

Nery Jr · Accepted Answer · 2017-08-25 16:53:51Z

8

You can let Sqlite itself check this out for you:

CREATE TABLE IF NOT EXISTS <table_name> ...;

Follow link for documentation: https://sqlite.org/lang_createtable.html

answered Aug 25, 2017 at 16:53

Nery Jr

4,0271 gold badge28 silver badges24 bronze badges

3 Comments

Rodney Salcedo Over a year ago

This is the way!

Dareon Over a year ago

Well for the database itself yes but what if I have lot of things to do in the app before even calling this? I can save compute time and resources if I am able to check before.

JChen___ Over a year ago

This is the right answer!

asmad · Accepted Answer · 2013-12-20 09:29:19Z

Use this code

SELECT name FROM sqlite_master WHERE type='table' AND name='yourTableName';

if returning array count is equal to 1 its means table exist else not exist.

Collectives™ on Stack Overflow

sqlite - how to check if table exists before completing inserts? [duplicate]

3 Answers 3

2 Comments

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Linked

Related