how to show all database size mb or gb wise in sql server

select sd.name,
round(sum(db.size) * 8 / 1024, 0) size_mb,(sum(db.size) * 8 / 1024) / 1024 as size_gb
from sys.master_files db inner join sys.databases sd on sd.database_id = db.database_id
group by sd.name
order by sd.name