List all tables in SQLite database. http://stackoverflow.com/questions/82875/how-do-i-list-the-tables-in-a-sqlite-database-file

schema_list_tables.sql

SELECT name FROM sqlite_master 
WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%'
UNION ALL 
SELECT name FROM sqlite_temp_master 
WHERE type IN ('table','view') 
ORDER BY 1