sql server - How to get detailed info about localdb

List of installed local DBs:

sqllocaldb i

Output:

MSSQLLocalDB

More details about selected:

sqllocaldb info MSSQLLocalDB

Output:

Name:               MSSQLLocalDB
Version:            15.0.4382.1
Shared name:
Owner:              domain\pirklj
Auto-create:        Yes
State:              Running
Last start time:    14.10.2025 14:36:27
Instance pipe name: np:\\.\pipe\LOCALDB#FF67DE7F\tsql\query

List of installed DBLocal versions:

sqllocaldb versions

Output:

Microsoft SQL Server 2016 (13.0.7037.1)
Microsoft SQL Server 2017 (14.0.3391.2)
Microsoft SQL Server 2019 (15.0.4382.1)
Microsoft SQL Server 2022 (16.0.1000.6)

Stopping and deleting of DBLocal instance, creating it with new higher version:

C:\Users\pirklj>sqllocaldb stop MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" stopped.

C:\Users\pirklj>sqllocaldb delete MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" deleted.

C:\Users\pirklj>sqllocaldb create MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" created with version 16.0.1000.6.

C:\Users\pirklj>sqllocaldb start MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" started.