list-tables-and-show-schema.md

List tables and show schema from SQLite cli

In the SQLite cli, many commands are dot-prefixed.

To see a list of tables:

.tables

To see the schema of a table:

.schema TABLENAME

Read the official documentation for more detail. Hat tip to this Stack Overflow post.