Show full schema

text

.schema

Explanation

Good for inspecting tables, indexes, triggers, and views.

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

Show table names in the current 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