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

3 votes351 views2 answers
Synonym oracle
SQL
0 vote311 views1 answer
Sql dmv to capture updates
SQL
0 vote308 views1 answer
Mssql now diff 90 day
SQL
1 vote270 views1 answer
Foreign key in oracle sql developer
SQL
0 vote279 views1 answer
How to count null values in sql
SQL
0 vote338 views1 answer
How to create notes in mysql
SQL
0 vote301 views1 answer
Safe mysql
SQL
11 votes317 views5 answers
Sql server reset identity
SQL
0 vote296 views1 answer
Minus equivalent in my sql
SQL
0 vote291 views1 answer
Sort by last two number sql
SQL