Android- Must I check if table exists in SqliteHelper.onCreate()?

Question

I move database create table from Applcation.onCreate to SqliteHelper.onCreate.

In Application, I must check if table already exists. But in SqliteHelper, as it's called on creation of database file, I don't think it's nessasary to use "IF NOT EXISTS"

CREATE TABLE {TABLE_NAME} IF NOT EXISTS (_id bla bla);

Can I change this sql to below?

CREATE TABLE {TABLE_NAME} (_id bla bla)

EDIT ---------

I asked if SqliteHelper.onCreate can called several times.

See this http://stackoverflow.com/questions/16571969/sqliteexception-table-already-exists/16572000#16572000 — Triode, Dec 31 '13 at 11:56

score 3 · Answer 1 · answered Dec 31 '13 at 12:00

3

onCreate() will only be called if the database does not exist. Adding IF NOT EXISTS is therefore not necessary and would only confuse people reading and maintaining the code.

Also, the syntax would be CREATE TABLE IF NOT EXISTS table_name.

answered Dec 31 '13 at 12:00

laalto

150,114
66
286
303

score 2 · Accepted Answer · answered Dec 31 '13 at 11:58

2

Yes you can. But the first method is always encouraged!

answered Dec 31 '13 at 11:58

AabidMulani

2,325
1
28
47

Thanks. I think this's the answer. – ceram1 Dec 31 '13 at 12:08

Android- Must I check if table exists in SqliteHelper.onCreate()?

2 Answers2

Linked