Titanium: How to check Table is exists or not in Database?

Question

How can I check weather specific table does exists or not in my database before execute query ?

Example : I want to check weather Detail table exists or not in InfoDB

I want to do some thing like :-

var createDB = Titanium.Database.open('InfoDB');
if(Detail exists in InfoDB)
  then
    var rs = createDB.execute('SELECT * FROM Detail');

Thanks...

db.execute('CREATE TABLE IF NOT EXISTS you can do some thing like this to create the table, not a solution but a tip — Triode, Feb 29 '12 at 13:40

score 10 · Accepted Answer · answered Feb 29 '12 at 13:39

10

Try this:

var createDB = Titanium.Database.open('InfoDB');

var result = createDB.execute('SELECT name FROM sqlite_master WHERE type="table" AND name="your table name"');

if(result.isValidRow()) {
    //table found
   var rs = createDB.execute('SELECT * FROM Detail');
 }
 result.close();

answered Feb 29 '12 at 13:39

Muhammad Zeeshan

8,722
10
45
55

I want to check before the execute query ! – Maulik Feb 29 '12 at 14:28
The first execute is actually fetching your table from sqlite db script `sqlite_master`. – Muhammad Zeeshan Feb 29 '12 at 14:36

score 2 · Answer 2 · answered Feb 29 '12 at 14:34

2

Solved ! I use alternate way. I use try...catch instead.

var createDB = Titanium.Database.open('InfoDB');
try
{
   var rs = createDB.execute('SELECT * FROM Detail');
}
catch(err)
{
   alert(err)
}

answered Feb 29 '12 at 14:34

Maulik

19,348
14
82
137

score 0 · Answer 3 · answered Sep 05 '16 at 08:45

0

if you like to check that before creating table

db.execute('CREATE TABLE IF NOT EXISTS Detail (..columns..)')

or dropping table

db.execute('DROP TABLE IF EXISTS Detail')

avoids table exists or table not exists errors.

answered Sep 05 '16 at 08:45

ilker

190
5
11

Titanium: How to check Table is exists or not in Database?

3 Answers3