SELECT
S.name as 'Schema_Name',
T.name as 'Table_Name',
I.name as 'Index_Name',
F.Avg_Fragmentation_in_Percent,
F.Page_Count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) as F
INNER JOIN sys.tables as T ON T.object_id = F.object_id
INNER JOIN sys.schemas as S ON T.schema_id = S.schema_id
INNER JOIN sys.indexes as I ON I.object_id = F.object_id
AND F.index_id = I.index_id
WHERE F.database_id = DB_ID()
AND I.name IS NOT NULL
AND F.avg_fragmentation_in_percent > 0
ORDER BY F.avg_fragmentation_in_percent DESC