SQLite DB

Dot commands

CommandMeaning
.databasesList names and files of attached databases.
.indexes ?TABLE?Show names of all indexes.
.schema ?PATTERN? Show the CREATE statements matching PATTERN. Add --indent for pretty-printing.
.showShow the current values for various settings
.tables ?TABLE? List names of tables If TABLE specified, only list tables matching LIKE pattern TABLE.
.dumpDump database in SQL text format.