RealDevTips > Development > SQL and databases > Transact SQL: Get list of all databases in server

Transact SQL: Get list of all databases in server

Published on March 24, 2016 by Aleksei

How to get as SQL query result the list of databases in SQL server.

select name, database_id  from sys.databases