in reply to determining table structure in SQLite database
DBI has various Catalog Methods. See the column_info and/or table_info methods of the database handle, which return a resultset from which you can fetch the information.