TableName       IndexName               FileGroupName
CacheData       PK_CacheData            PRIMARY
CENSUSTRACTS    NULL                    PRIMARY
CMACCOUNT       PK__SFACCT__4D35603F    PRIMARY

SELECT OBJECT_NAME( i."id" ) AS TableName ,
       i."Name" AS IndexName ,
       FILEGROUP_NAME( i.groupid ) AS FileGroupName
FROM sysindexes AS i
WHERE ( i.indid IN ( 0 , 1 ) Or i.indid < 255 ) And -- Tables & indexes only
      OBJECTPROPERTY( i."id" , 'IsUserTable' ) = 1 And -- User tables only
      OBJECTPROPERTY( i."id" , 'IsMSShipped' ) = 0 And -- No system tables
      COALESCE( INDEXPROPERTY( i."id" , i."Name" , 'IsStatistics' ) , 0 ) = 0 And -- No Statistics / Auto-Create stats
      COALESCE( INDEXPROPERTY( i."id" , i."Name" , 'IsHypothetical' ) , 0 ) = 0   -- No Hypothetical statistics
ORDER BY FileGroupName , TableName , IndexName