sqlite3 database meta information

After being pretty unsuccesful trying to read the docs for sqlite3 table metadata, last evening we managed to pull these sql statements out of the rails sqlite3 adatapter code:

PRAGMA table_info(table_name)
SELECT name FROM sqlite_master WHERE type = 'table'
PRAGMA index_list(table_name)
PRAGMA index_info('index_name')