SQL Server: How to find all localdb instance names

Question

I have two versions (2012, 2014) of SQL Server Express LocalDB installed in my system.

How can I find all existing LocalDB instance names?

I found a way to do that using command line as mentioned in the answers section.

Is there a better and easy way to do it?

Answer 1

I found SqlLocalDB utility that needs to be run on command line.

SqlLocalDB can be found in

C:\Program Files\Microsoft SQL Server\110\Tools\Binn 

or

C:\Program Files\Microsoft SQL Server\120\Tools\Binn 

To get all existing LocalDB instance names, use:

SqlLocalDB.exe i   info|i   Lists all existing LocalDB instances owned by the current user   and all shared LocalDB instances. 

To get detailed information about a specific LocalDB instance:

SqlLocalDB.exe i "MSSQLLocalDB"  info|i "instance name"   Prints the information about the specified LocalDB instance. 

Answer 2

To list all localdb instances, take a look vineel's answer below!

---

If you want to list all databases of your default localdb instance using UI, look here (might not work with SSMS2019 anymore):

Just open your SSMS and connect to (LocalDB)\MSSQLLocalDB.
Now you will see all your LocalDB-Instances.

This works at least with SS2016.