SQL and ML Spaces

SELECT database_id AS DBID, DB_Name(database_id) AS DBName, file_id, name AS FileName, type_desc,
data_space_id, state_desc, (size *8/1024) AS SizeInMB, max_size, is_media_read_only, is_read_only, is_sparse, is_percent_growth, differential_base_lsn, backup_lsn, physical_name
FROM sys.master_files
ORDER BY type_desc, file_id