sp_spaceused Returns information about the total size of the database

Syntax:

Exec sp_spaceused

OUTPUT:

database_name database_size unallocated space
-----------------------
myDB 3.00 MB 0.74 MB

reserved data index_size unused
------------------ ------------------ ------------------ ------------------
1288 KB 584 KB 632 KB 72 KB

Thanks:)