· 8 years ago · Apr 13, 2018, 01:46 AM
1SELECT name FROM sqlite_master WHERE type='table' AND name='table_name';
2
3create table if not exists TableName
4
5drop table if exists TableName
6
7SELECT name FROM sqlite_master WHERE name='table_name'
8
9SELECT name FROM sqlite_master
10WHERE type='table'
11ORDER BY name;
12
13SELECT CASE WHEN tbl_name = "name" THEN 1 ELSE 0 END FROM sqlite_master WHERE tbl_name = "name" AND type = "table"