How to get Database ID and Name in Sql Server

By JC.Adinarayana Reddy On 20 Dec 2016
Categories: Sql Server

To get a list of Database ID's and Names in your Sql Server use the below query.

SELECT [name],[dbid] FROM [master].[dbo].[sysdatabases] ORDER BY [name]

Comments

Message :

Comments