sp_spaceused (Transact-SQL)

​Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

database_name
nvarchar(128)
Name of the current database.

database_size
varchar(18)
Size of the current database in megabytes. database_size includes both data and log files.

unallocated space
varchar(18)
Space in the database that has not been reserved for database objects.

reserved
varchar(18)
Total amount of space allocated by objects in the database.

data
varchar(18)
Total amount of space used by data.

index_size
varchar(18)
Total amount of space used by indexes.

unused
varchar(18)
Total amount of space reserved for objects in the database, but not yet used.