SQLite syntax error | check the presence of the table

Question

"EXISTS": syntax error (code 1):, while compiling: ALTER TABLE IF EXISTS CW_Elem ADD COLUMN Type TEXT;

database.execSQL("ALTER TABLE IF EXISTS " + groups + "_" + title + " ADD COLUMN " + str + " TEXT;");

How then to check the presence of the table and if it is to execute the request? Please help!

score 0 · Answer 1 · answered Feb 21 '18 at 22:52

0

Look at the syntax diagrams for SQLITE. Try alter table

answered Feb 21 '18 at 22:52

andy mango

How then to check the presence of the table and if it is to execute the request? – RealSR Feb 21 '18 at 23:39
That's a different question. You asked about the syntax error. Perhaps an SQL expert can help. – andy mango Feb 21 '18 at 23:46

1 Answers1