Querying The Database Schema

puts [db eval {SELECT name FROM sqlite_master WHERE type='table'}] t1

puts [db onecolumn {SELECT sql FROM sqlite_master WHERE name='t1'}] CREATE TABLE t1(a,b,c)