sql server查询数据库占用空间以及某个表占用的空间

use 数据库名;

EXEC sp_spaceused '数据库表名';

SELECT
    type_desc,
    name AS FileName,
    physical_name AS PhysicalName,
    size/128.0 AS CurrentSizeMB,
    max_size/128.0 AS MaxSizeMB
FROM sys.database_files;