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 vote259 views1 answer
Sql count more than 1
SQL
0 vote262 views1 answer
Find usage of table in sql server
SQL
0 vote253 views1 answer
Limit and offset in stored procedure mssql
SQL
3 votes260 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote262 views1 answer
Window function to forward fill
SQL
0 vote253 views1 answer
Sqlite commands
SQL
1 vote262 views1 answer
Adding a check statement in sql
SQL
0 vote249 views1 answer
Restore backupfile discourse
SQL
0 vote244 views1 answer
Redirection 301 htaccess nom de domaine
SQL
4 votes257 views3 answers
How to describe a table in sqlite3
SQL