SELECT
    size / 128.0 AS fileSize,
    file_id AS fileId,
    FILEPROPERTY (name,
                  'SpaceUsed') / 128.0 AS fileUsed,
    CASE WHEN
    max_size = - 1 OR
    max_size = 268435456
    THEN - 1
    ELSE max_size / 128 END AS fileMaxSize,
    CASE WHEN growth = 0 THEN 0
    ELSE 1 END AS IsAutoGrow,
    is_percent_growth AS isPercentGrowth,
    growth AS fileGrowth,
    physical_name
FROM sys.master_files WITH (NOLOCK)
WHERE
    type IN (0, 1) AND
    is_read_only = 0 AND
    database_id = 5

SELECT
    size / 128.0 AS fileSize,
    file_id AS fileId,
    FILEPROPERTY (name,
                  'SpaceUsed') / 128.0 AS fileUsed,
    CASE WHEN
    max_size = - 1 OR
    max_size = 268435456
    THEN - 1
    ELSE max_size / 128 END AS fileMaxSize,
    CASE WHEN growth = 0 THEN 0
    ELSE 1 END AS IsAutoGrow,
    is_percent_growth AS isPercentGrowth,
    growth AS fileGrowth,
    physical_name
FROM sys.master_files WITH (NOLOCK)
WHERE
    type IN (0, 1) AND
    is_read_only = 0 AND
    database_id = 5