The sqlite3 CLI takes the database file followed by commands; dot-commands like .tables are CLI meta-commands rather than SQL. It lists tables and views. Related: .schema.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.