Meta Commands
| Backup DB (default "main") to FILE |
| Stop after hitting an error. Default OFF |
| List names and files of attached databases |
| Dump the database in an SQL text format. |
| Turn command echo on or off |
| Exit this program |
| Turn output mode suitable for EXPLAIN on or off. |
| Turn display of headers on or off |
| Shows this information. |
| Import data from FILE into TABLE |
| Show names of all indices |
| Load an extension library |
| Turn logging on or off. FILE can be stderr/stdout |
| Set output mode where MODE is one of: csv, column, html, insert, line, list, tabs, tcl |
| Print STRING in place of NULL values |
| Send output to FILENAME |
| Send output to the screen |
| Replace the standard prompts |
| Exit this program |
| Execute SQL in FILENAME |
| Restore content of DB (default "main") from FILE |
| Show the CREATE statements |
| Change separator used by output mode and .import |
| Show the current values for various settings |
| Turn stats on or off |
| List names of tables |
| Try opening locked tables for MS milliseconds |
| Set column widths for "column" mode |
| Turn the CPU timer measurement on or off |
Options
| Read and execute commands from file , which can contain a mix of SQL statements and meta-commands. |
| Print commands before execution. |
| Turn headers on or off. |
| Stop after hitting an error. |
| Force interactive I/O . |
| Force batch I/O . |
| Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output. |
| Set output mode to CSV (comma separated values). |
| Query results will be output as simple HTML tables. |
| Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs |
| Query results will be displayed with the separator (|, by default) character between each field value. The default. |
| Set output field separator. Default is "|". |
| Print memory stats before each finalize. |
| Set string used to represent NULL values. Default is (empty string). |
| Show SQLite version. |
| Use name as the default VFS . |
| Show help on options and exit. |
Notes
- Based on sqlite3 cheat sheet by richardjh