From Mauricio Piacentini:
SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to create and compact database files, create, define, modify and delete tables, create, define and delete indexes, browse, edit, add and delete records, search records, import and export records as text, import and export tables from/to CSV files, import and export databases from/to SQL dump files, issue SQL queries and inspect the results, and examine a log of all SQL commands issued by the application.
read more +
DB Browser for SQLite features importing and exporting capabilities, with support for SQL and CSV formats. Furthermore, it enables you to write SQL queries, execute them and view the returned data. Sqlite follow Application file format which is cross platform file format that allows of copying database between 64bit and 32 bit systems.Sqlite database component catalog includes table, triggers and views.So to explorer these components Sqlite Browser is the best option.