One Quickie

Describe table in sqlite3 (sqlite3->General)
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);

borkware home | products | miniblog | rants | quickies | cocoaheads
Advanced Mac OS X Programming book