SQLite3 Shell: How to get database filename inside .sql file

Question

I'm writing a .bat file that calls sqlite3 shell (opens existing database file) and passes an .sql file with commands into it. It looks like following in .bat file:

sqlite3 %1 < "%~0\..\xtra.sql"

, where %1 is path to database file.

The problem is - in .sql script I need to use filename of database; but I can't find any information which command use to get it. Alternatively,if there is a way to pass parameters into sqlite3 shell (like into windows cmd), I could use it too.

MC ND · Accepted Answer · 2017-05-31 08:26:01Z

2

The pragma database_list; command will return the list of currently attached databases. This information can be retrieved as a table-valued function (from version 3.16.0, documented here).

As you need your default database file, then if you are using an updated sqlite shell version, you can use

select file from pragma_database_list where name='main';

answered May 31, 2017 at 8:26

MC ND

71.1k8 gold badges95 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite3 Shell: How to get database filename inside .sql file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related