interview

home / developersection / interviews / how to get a list all databases?

How to get a list all databases?

Amit Singh 1975 09-Nov-2010

mssql server

Updated on 17-Sep-2020

Amit Singh

Other

Message

Can you answer this question?

1 Answers

09-Nov-2010

we get a list of all databases on the server by query the "sys.databases"

for example

SELECT name, database_id FROM sys.databases

advertising