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.