select
logical_name
, physical_name
, [朱.レ]
, substring(reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)), 1, charindex('.', [朱.レ])-1) [朱]
, substring(reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)), charindex('.', [朱.レ])+1, len([朱.レ])) [レ]
from (
SELECT
name logical_name
, physical_name
, reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)) [朱.レ]
FROM sys.database_files WHERE type = 0
) t