SQLite3

open file with: sqlite3 <<DB-FILE-NAME>>

.tables	show all tables in database
.schema <<TABLENAME>>	show how this table was created