Quickstart SQLite tutorial Jan 2, 2011 • Noel -- create table create table Cake ( id integer not null, name text, price real ); create table Drink ( id integer primary key, name text ); -- insert ... insert into Cake values (7, 'Victoria sponge', 3.2); -- show tables .tables