We have a multi-db setup on a stand-alone server. We can change the db which we query by :use ... where ... is the database to which queries are directed.

I would like to know if there is a query we can run to check which database we are currently running queries to, something like SHOW ACTIVE DATABASE or something like that.

Tried ACTIVE, CURRENT but neither seems to work. Tried checking for a field in SHOW DATABASES which may indicate the database I am currently querying towards. Nothing there either...

This should be possible but I couldn't find any documentation to it.

CodePudding user response：

You can use the following query :

CALL db.info()
YIELD name