Include internal objects useful for advanced debugging.
Section: Open and inspect databases
Show schema plus sqlite_stat tables
text
text
.fullschemaExplanation
Helpful when investigating query-planner behavior and generated internal objects.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Open and inspect databases
Open a database file
Start the sqlite3 shell with a file-backed database.
Open an in-memory database
Start a temporary database that lives only for the session.
Show schema for one table
Print the CREATE statement for a specific object.