How to check if a table exist in SQLite

You should use the sqlite_master table to look up if a table exists.

In php you would to the following.

$db = new SQLite3('mydb.sqlite3')
$tableCheck =$db->query(
  "SELECT name FROM sqlite_master WHERE name='myTableName'");
if ($tableCheck->fetchArray() === false){
  doMyInitializeThing($db);
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s