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 ...

List all SQLite databases. To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command:. sqlite>.databases main: ...

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.