SELECT 
    DB_NAME(DB_ID()) AS DatabaseName,
    O.[name] AS TabellenName,
    SIX.[Name] AS IndexName,
    IXStats.avg_fragmentation_in_percent,
    SIX.type_desc AS Indextyp
FROM 
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) IXStats
    JOIN 
    sys.indexes SIX ON IXStats.[object_id] = SIX.[object_id] AND IXStats.index_id = SIX.index_id
    JOIN
    sys.objects O ON SIX.[object_id] = O.[object_id]
WHERE 
    IXStats.database_id = DB_ID()
ORDER BY 
    IXStats.avg_fragmentation_in_percent DESC