Get Last 10 Database name in SQL Server

Last 10 database name:

Select top 10 name,database_id,create_date FROM sys.databases ORDER BY database_id desc