Open a database

1sqlite> .open test.db

Show tables

1sqlite>.table
2n

Shows that there is only 1 table named n.

Check table schema

1sqlite> .schema
2CREATE TABLE n (id INTEGER PRIMARY KEY,f TEXT,l TEXT);

Check contents of a table

It's just the usual sql query commands as expected

1sqlite> select * from n;
21|john|smith

Quit the sqlite command prompt

1sqlite> .quite

Check for other command not covered above in sqlite.org website