SELECT 
   objz.[name], 
   objz.[type], 
   idxz.[name], 
   idxz.[index_id], 
   CASE idxz.[index_id]
     WHEN 0 THEN 'HEAP'
     WHEN 1 THEN 'CLUSTERED'
     ELSE 'NON-CLUSTERED'
   END AS index_type,
   filz.[name]
 FROM sys.indexes idxz
 INNER JOIN sys.filegroups filz
 ON idxz.data_space_id = filz.data_space_id
 INNER JOIN sys.all_objects objz
 ON idxz.[object_id] = objz.[object_id]
 WHERE idxz.data_space_id = filz.data_space_id
 AND objz.type_desc IN( 'USER_TABLE') -- User Created Tables

SELECT 
	o.[name] AS ObjectName, 
	o.[type] AS ObjectType,
	s.[name] AS SchemaName,
	f.[name] AS [Filename],
	i.[name] AS PrimaryKey, 
	i.[index_id] AS IndexID
FROM 
	sys.indexes i
INNER JOIN 
	sys.filegroups f
	ON 
	i.data_space_id = f.data_space_id
INNER JOIN 
	sys.all_objects o
	ON 
	i.[object_id] = o.[object_id]
INNER JOIN 
	sys.schemas s
	ON 
	s.[schema_id] = o.[schema_id]
order by 
	s.[name],
	o.[name]