SELECTps.nameASPSName,
dds.destination_idASPartitionNumber,
fg.nameASFileGroupName,fg.name,
t.name,
f.nameasfilename
FROM(((sys.tablesASt
INNERJOINsys.indexesASi
ON(t.object_id=i.object_id))
INNERJOINsys.partition_schemesASps
ON(i.data_space_id=ps.data_space_id))
INNERJOINsys.destination_data_spacesASdds
ON(ps.data_space_id=dds.partition_scheme_id))
INNERJOINsys.filegroupsASfg
ONdds.data_space_id=fg.data_space_id
innerjoinsys.database_filesfonf.data_space_id=fg.data_space_id
wheret.name='salesOrder'