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