How to list tables in a sqlite database.

the following query will list the tables in a sqlite database.
SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;