Books Online is your friend 🙂

As for your query ... this should fix ya up, let me know ...

SELECT

a.index_id

,b.name

,avg_fragmentation_in_percent

,c.name

,d.name

,e.name

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL,NULL, NULL, NULL) AS a

JOIN sys.indexes AS b

ON a.object_id = b.object_id AND a.index_id = b.index_id

AND a.index_id = b.index_id

JOIN sys.objects AS c

ON c.object_id = a.object_id

JOIN sys.schemas AS d

ON d.schema_id = c.schema_id

JOIN sys.databases AS e

ON e.database_id = DB_ID()