DB Browser for SQLite is a free, open source tool to create, design, and edit SQLite databases. You can downloaded it from
Some of its features:
- Create, define, modify and delete tables
- Create, define and delete indexes
- Browse, edit, add and delete records
- Import and export tables from/to other formats
Here's what the table definition of the table Countries of database Geo.sqlite looks like:
For SQLite, the field type VARCHAR(n) means the same as the type TEXT.
But for Delphi, it's different. In a DBGrid component, Delphi displays the contents of columns of the type VARCHAR(n) as strings, while for the type TEXT it only displays the mention (Memo).
The (50) in VARCHAR(50) is used by Delphi for the length of the field-data and the
width of the columns of a TDBGrid.