DB Browser for SQLite

Viewing a table's structure.

DB Browser for SQLite, originally called "SQLiteBrowser," is a cross platform free and open source viewer for SQLite databases created by Mauricio Piacentini in C++, and first released on 2003-08-19. It is designed for both developers and users in mind, so it's both powerful and easy to use. The program is a must for anyone struggling with SQLite's command line functions.