Table of Contents
Manage SQLite databases
Creating a SQLite database
sqlite3 should be in your path.
To create a new database named newdb with a table newtable:
admin$ sqlite3 newdb SQLite version 3.5.2 Enter ".help" for instructions sqlite> create table newtable(id varchar(10), column smallint);