Transact SQL: Get list of all databases in server

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

select name, database_id  from sys.databases