list of sqlite commands

Solutions on MaxInterview for list of sqlite commands by the best coders in the world

Search
showing results for - "list of sqlite commands"
Hailee
10 Oct 2020
1sqlite> .help
2.archive ...             Manage SQL archives
3.auth ON|OFF             Show authorizer callbacks
4.backup ?DB? FILE        Backup DB (default "main") to FILE
5.bail on|off             Stop after hitting an error.  Default OFF
6.binary on|off           Turn binary output on or off.  Default OFF
7.cd DIRECTORY            Change the working directory to DIRECTORY
8.changes on|off          Show number of rows changed by SQL
9.check GLOB              Fail if output since .testcase does not match
10.clone NEWDB             Clone data into NEWDB from the existing database
11.databases               List names and files of attached databases
12.dbconfig ?op? ?val?     List or change sqlite3_db_config() options
13.dbinfo ?DB?             Show status information about the database
14.dump ?TABLE? ...        Render all database content as SQL
15.echo on|off             Turn command echo on or off
16.eqp on|off|full|...     Enable or disable automatic EXPLAIN QUERY PLAN
17.excel                   Display the output of next command in a spreadsheet
18.exit ?CODE?             Exit this program with return-code CODE
19.expert                  EXPERIMENTAL. Suggest indexes for specified queries
20.fullschema ?--indent?   Show schema and the content of sqlite_stat tables
21.headers on|off          Turn display of headers on or off
22.help ?-all? ?PATTERN?   Show help text for PATTERN
23.import FILE TABLE       Import data from FILE into TABLE
24.imposter INDEX TABLE    Create imposter table TABLE on index INDEX
25.indexes ?TABLE?         Show names of indexes
26.iotrace FILE            Enable I/O diagnostic logging to FILE
27.limit ?LIMIT? ?VAL?     Display or change the value of an SQLITE_LIMIT
28.lint OPTIONS            Report potential schema issues.
29.load FILE ?ENTRY?       Load an extension library
30.log FILE|off            Turn logging on or off.  FILE can be stderr/stdout
31.mode MODE ?TABLE?       Set output mode
32.nullvalue STRING        Use STRING in place of NULL values
33.once (-e|-x|FILE)       Output for the next SQL command only to FILE
34.open ?OPTIONS? ?FILE?   Close existing database and reopen FILE
35.output ?FILE?           Send output to FILE or stdout if FILE is omitted
36.parameter CMD ...       Manage SQL parameter bindings
37.print STRING...         Print literal STRING
38.progress N              Invoke progress handler after every N opcodes
39.prompt MAIN CONTINUE    Replace the standard prompts
40.quit                    Exit this program
41.read FILE               Read input from FILE
42.restore ?DB? FILE       Restore content of DB (default "main") from FILE
43.save FILE               Write in-memory database into FILE
44.scanstats on|off        Turn sqlite3_stmt_scanstatus() metrics on or off
45.schema ?PATTERN?        Show the CREATE statements matching PATTERN
46.selftest ?OPTIONS?      Run tests defined in the SELFTEST table
47.separator COL ?ROW?     Change the column and row separators
48.session ?NAME? CMD ...  Create or control sessions
49.sha3sum ...             Compute a SHA3 hash of database content
50.shell CMD ARGS...       Run CMD ARGS... in a system shell
51.show                    Show the current values for various settings
52.stats ?on|off?          Show stats or turn stats on or off
53.system CMD ARGS...      Run CMD ARGS... in a system shell
54.tables ?TABLE?          List names of tables matching LIKE pattern TABLE
55.testcase NAME           Begin redirecting output to 'testcase-out.txt'
56.timeout MS              Try opening locked tables for MS milliseconds
57.timer on|off            Turn SQL timer on or off
58.trace ?OPTIONS?         Output each SQL statement as it is run
59.vfsinfo ?AUX?           Information about the top-level VFS
60.vfslist                 List all available VFSes
61.vfsname ?AUX?           Print the name of the VFS stack
62.width NUM1 NUM2 ...     Set column widths for "column" mode
63sqlite>
64
source
similar questions
sqlite show columnssqlite3 show columns namesqlite woth cmakesqlite max database sizesqlite display headers on columnssqlite show table indexessqlite explain plansqlite version checksqlite indexestop in sqlitesqlite commandssqlite describe tableshowing all columns in an sqlite tablesqlite show table structureis sqlite installed as part of python3list tables sqliteall sql commands with examplesdescribe in sqlite3
queries leading to this page
how to know if db call is complete sqlitesqlite3 commandasqlite3 connect to database command linesqldb command cmdsqlite commandsqlite database filesqllte command linuse sqlite in cmddisplay sqlite data in shellhow to use sqlite3 exesqlite cli open databasesqlite command notworkingexit sqlite3 promptopen db file sqliteusing sqlite in cmdsqlite cmd show idhow to check database in sqlite3how to view a sqlite databaseconnect to sqlite database terminalview sqlite db fileopen sqlite filesqlite 3 db from sqlsqlite command line select databasesqlite show contents of tablesqlite dot commandscheck sqlite connections unixhow to view database tables in sqlite using command prompt in windowssqlite command linereading db sqliteobserving table contents sqlite3windows sqlite get filesqlite all commandview sqlite database in cmd sqlite command line use databasehow to access a sqite tablehow to access a db sqlitesqlite3 read sql filehow to use sqlite3 in terminalsqlite3 open file databasehow to view sqlite database in cmdhow to open a sqlite table in terminal sqlite select databaseread sqlite db filerun a chema file sqlitecheck sqlite version windowssqllite db consolesqlite check entries in table command linehow to create table sqlite3 linuxhow to write sqlite command lineopen database sqlite3sqlite command line ioensqlite command line toolsqlite for mac exitrun sqlite command linehow to access sqlite database in command linesql lite cmdcheck databases inside sqlitelist sqlite3 commandssqlite cmdsqlite commands filedopen sqlite3 windows commandsqlite commandssqlite show databaseshow to run sqlite3 from command linehow to print all users in sqlite databasecommands for sqlite3how to show users in sqlitehow to open sqlite in cmdsee sqlite3 contentusing sqlite3get database sqlite 3 onto serverhow to use sqlitesqlite3 is backend or clisqlite queries for terminal all commands table not foundsqlite access table content in cmdsql lite commads sqlite list all datasqlite command from fileshow sqlite contenthow to use sqlite3 in cmduse db sqlite 3show sqlite database in terminalsqlite list databasessqlite3 command promptsqlite3 exesqlite exit commandhow to open sqlite 3 in terminalaccessing sqlite 3 database from terminalhow to open db sqlite3 filesqlite show table contentcommand sqlite3sqlite3 read db filesqlite open fileshow all commands sqlite3view sqlite tablessqlite query databasesqlite3 not a commandconnect to sqlite from command line opening session sqliteconnected to a transient in memory database access sqlite from terminalread sqlite fileview sqlite databasehow to read sqlite file in terminalsqlite3 shell open dbsee contents of sqlite filesqlite3 open filesqlite from command linesqlite display modesqlite terminal commandsuse database sqlite3how to conect schema sgl to transient in memory databasesqlite queries for terminal all commandssqlite commands connecting to datbase linuxsqlite3 commandsqlite modessqlite make table command promptlist of sqlite commands separator sqlitesqlite commendhow to use sqlite command linesqlite3 directorycmd sqlite3 tablesview contents of sqlite databaseview sqlite database command lineaccess sqlite databasesqlite show all databasesqlite3 db filesqlite all commandscommand to print a table sqlite3see sqlite databaselaunch sqlite clihow to run a sqlite query from terminalsqlite3 commandssqlite cmd acces table contentsqlite3 cli read tablesqlite access in windowshow to drun db sqlite from terminalsqlite shell see databasestransient in memory databasesqllte command linelinux find sqllite databasesqlite3 cmd line show table contentsqlite 3 show contents of databaseconnect to sqlite database terminal windowscreate sqlite database command linesqlite create table from command lineuse database command in sqlite3sqlite3 cli create tablei found an sqlite database how do i get ithow to access sqlite databasesqlite cmdhow view db sqllite filesqlite dot commands onlinhow to view user in sqlitehow to view sqlite databasesqlite version checkrun sqlite3 from command linehow to view db sqlite3 fileaccess sqlite3 databasesee the structure of a sqlite filehow to creat a table in sqlite3 using terminalread sqlite file command lineterminal 3e in sqlitemysql lite commandssqlite 3 common commandhow to run sqlite on teminallist of sqlite commands