SQLite List all tables in database

How to get list of all tables in SQLite?

Just type the script below:

SELECT * FROM sqlite_master WHERE type='table'