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);