sqlite - how to check if table exists before completing inserts? [duplicate]

Question

What is the best SQL for a SQLite database to effectively do:

If Database Table Exists then   - create table   - insert row   - insert row (i.e. for startup data) end 

Answer 1

To check that your table exists or not, you can use:

SELECT * FROM sqlite_master WHERE name ='myTable' and type='table';