sqlite> CREATE TABLE Servers( Hostname TEXT PRIMARY KEY, IPAddress TEXT, Role TEXT, Status TEXT, Timestamp INT ); sqlite> .tables Servers That’s a fairly standard CREATE SQL statement ...

Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE foo(bar razzamataz,ch text,fl real,whl int,mess blob); sqlite> .dump foo PRAGMA foreign_keys=OFF; ... Transaction control ...

Creating and using an SQLite database for data persistence in Android apps. ... For the sample app, we are going to create two tables, an Employer table and an Employee table.