List tables

text

.tables

Explanation

Fast way to discover tables and virtual tables from the shell.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Open and inspect databases

Print CREATE statements for the whole database.

Open In sheettextsame section

Print the CREATE statement for a specific object.

Open In sheettextsame section

Start the sqlite3 shell with a file-backed database.

Open In sheetbashsame section

Start a temporary database that lives only for the session.

Open In sheetbashsame section

Show the main database and any attached files.

Open In sheettextsame section

Include internal objects useful for advanced debugging.

Open In sheettextsame section