How to list all database objects in Sqlite database

Execute the following query and you will see all the table definitions and view definition.

select *
from sqlite_master


Reference:
http://www.sqlite.org/faq.html#q7