list tables sqlite code example

Example: list tables sqlite

>sqlite3 c:\db\my_base						-- opens database
sqlite> .tables								-- all tables
sqlite> .table '%es'						-- tables ending with 'es'
-- Via SQL:
SELECT name FROM  sqlite_master 
WHERE type ='table' AND name NOT LIKE 'sqlite_%';