how to check if table exists in sqlite code example
Example 1: sql server check table exists
IF EXISTS
(SELECT object_id FROM sys.tables
WHERE name = 'Artists'
AND SCHEMA_NAME(schema_id) = 'dbo')
PRINT 'The table exists'
ELSE
PRINT 'The table does not exist';
Example 2: check if table exist sqlite java
Connection c = ...
DatabaseMetaData dbm = c.getMetaData();
// check if "employee" table is there
ResultSet tables = dbm.getTables(null, null, "employee", null);
if (tables.next()) {
// Table exists
}
else {
// Table does not exist
}