The following SQL Query provide list of databases:

SELECT name, database_id, create_date
FROM sys.databases;
GO

See also the Microsoft documentation for View list of databases on SQL Server