SELECT ps.name AS PSName, 
 dds.destination_idAS PartitionNumber, 
 fg.name AS FileGroupName,fg.name,
 t.name,
 f.name as filename
 FROM (((sys.tables AS t 
 INNER JOIN sys.indexes AS i
   ON (t.object_id = i.object_id)) 
 INNER JOIN sys.partition_schemes AS ps 
   ON (i.data_space_id = ps.data_space_id)) 
  INNER JOIN sys.destination_data_spacesAS dds 
   ON (ps.data_space_id = dds.partition_scheme_id))
  INNER JOIN sys.filegroups AS fg 
    ONdds.data_space_id =fg.data_space_id
    innerjoin sys.database_files f on f.data_space_id = fg.data_space_id
   where t.name='salesOrder'