Working With Multiple Databases

Page 27 of 41
[prev] [next]

The default database has the name "main". TEMP tables are in a separate database named "temp".

Example: A quick way to move data from one database to another:

ATTACH DATABASE 'backup.db' AS backup;
CREATE TABLE  backup.table1 AS SELECT * FROM table1;
DETACH DATABASE backup;