How to change database name in sqlite?

Question

I have to simply change name of database, but it seems the ALTER DATABASE command is not valid in SQLite.

My scenario is that I have a SQLite encrypted database, and now I want to rename it. After manually renaming the db file, encryption is not working. So I tried to change the database's name using command. It looks like problem is due to encryption.

@YaqubAhmad, if you're building queries in a multi-database environment, you need to explicitly specify the name. Copying those queries to a single-database environment would require removing the database name, unless you could give the single-database a name matching the one the queries are using. — Patrick
– Patrick, Commented Dec 15, 2013 at 2:01
For main specifically: stackoverflow.com/questions/7313190/can-i-name-sqlite-databases — Ciro Santilli OurBigBook.com
– Ciro Santilli OurBigBook.com, Commented Nov 22, 2015 at 21:45

score 16 · Accepted Answer · 2012-06-01 07:26:27Z

Each sqlite file contains one and only one database. This database bears no name. For what I can remember, the first opened database has a 'virtual' name main for when you want to refer to it say when you attach supplementary databases. You get to choose the 'virtual' name of databases you attach.

[someone@somewhere tmp]$ sqlite3 bla.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /tmp/bla.db                                  
sqlite> attach database 'example.db' as another_db;
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /tmp/bla.db                                  
2    another_db       /tmp/example.db

Otherwise Laurent is correct that you can rename the database file if that is what you are trying to do here.

laurent · Accepted Answer · 2012-06-01 07:15:04Z

12

There's no database name in SQLite because there's only one database per file. Maybe what you want to do is rename the SQLite file instead.

answered Jun 1, 2012 at 7:15

laurent

91.2k83 gold badges310 silver badges445 bronze badges

3 Comments

sagar Over a year ago

I tried that but the original file is encrypted and when I change filename same password is not working for it.

intijk Over a year ago

This is not true, sqlite allow you attach another database. And .databases would list them.

AKstat Over a year ago

The file name has nothing to do with the database name in SQLite. By default there are two databases main and temp.

Alexander Farber · Accepted Answer · 2015-08-27 20:14:09Z

2

In recent versions of Sqlite3 there is the .backup command.

If the database is not big this could be a solution:

S:\>sqlite3 encrypted.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .backup new.db
sqlite> .q

then

S:\>sqlite3 new.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

edited Aug 27, 2015 at 20:14

Alexander Farber

23.4k79 gold badges263 silver badges449 bronze badges

answered Jun 15, 2012 at 20:06

user1459387

211 bronze badge

Collectives™ on Stack Overflow

How to change database name in sqlite?

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related