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 vote291 views1 answer
Oracle INTERVAL DAY to second to number
SQL
-1 vote325 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote298 views1 answer
How to add more columns to a table in mysql
SQL
3 votes294 views2 answers
Truncate all tables
SQL
7 votes284 views3 answers
How to check table name in current database sql
SQL
0 vote301 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote304 views1 answer
Createdb with postgresql on ubuntu
SQL
11 votes318 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote280 views2 answers
How to check username in mysql command line
SQL
0 vote305 views1 answer
How to to get time in sql
SQL