Quickies for sqlite3

Borkware »
Quickies »
Quickies for sqlite3

General

Describe table in sqlite3 [permalink]
To see the table structure, use .schema

sqlite> .schema camp
CREATE TABLE camp (code INTEGER, label TEXT, state TEXT, type TEXT, phone TEXT, sites INTEGER, nforg TEXT, lat NUMERIC, lon NUMERIC, elevation NUMERIC, fee TEXT);
CREATE INDEX pkdex ON camp (code);