SELECT  OBJECT_NAME(object_id) AS TableName ,
        i.name AS IndexName ,
        ds.name AS FileGroupName
FROM    sys.data_spaces AS ds
        INNER JOIN sys.indexes AS i ON ds.data_space_id = i.data_space_id

We walk in the dark places no others will enter
We stand on the bridge and no one may pass