SQLite DB
Dot commands
Command | Meaning |
.databases | List 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. |
.show | Show the current values for various settings |
.tables ?TABLE? | List names of tables If TABLE specified, only list tables matching LIKE pattern TABLE. |
.dump | Dump database in SQL text format. |