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_%';

Source: sqlitetutorial.net

Similar codes

0 vote193 views1 answer
Acual month sql
SQL
2 votes250 views3 answers
Row number mssql
SQL
2 votes191 views1 answer
How to delete view in sql
SQL
0 vote195 views1 answer
Oracle sql winter time change
SQL
4 votes189 views2 answers
Tsql utf to local time
SQL
0 vote194 views1 answer
Pl sql join 3 tables
SQL
5 votes194 views3 answers
Truncate function in sql oracle
SQL
0 vote221 views1 answer
Minus equivalent in my sql
SQL
0 vote203 views1 answer
Increase speed of like queries postgres
SQL
0 vote263 views2 answers
Uninstall postgresql mac
SQL