Name
.dump — Produce an SQL dump file
Common Usage
.dump [table-pattern ...]Description
The .dump command generates a series of SQL
commands suitable to recreate one or more tables from the
database. If no parameters are given, every table in the
main database will be
dumped. If one or more parameters are given, only those tables
in the main database that
match the provided LIKE
patterns will be dumped. To record the .dump output to a file, use the .output command.
A dump will preserve the values in any ROWID alias column (an
INTEGER PRIMARY KEY
column), but it will not preserve more general ROWID values.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
