/* List all tables and other table info belonging to database 'demo'  */
/* Similar to command - show tables */

SELECT 	tbl_name 
FROM	sqlite_master 
WHERE 	type in ('table', 'view');


/* List all tables and other table information */

SELECT 	* 
FROM	sqlite_master 
WHERE 	type in ('table', 'view');