Find Index fragmentation based on table name

-- Replace 'YourDatabaseName', 'YourTableName', and 'YourIndexName'
USE YourDatabaseName;
GO

SELECT 
    dbschemas.[name] AS SchemaName,
    dbtables.[name] AS TableName,
    dbindexes.[name] AS IndexName,
    indexstats.index_id,
    indexstats.avg_fragmentation_in_percent,
    indexstats.page_count
FROM sys.dm_db_index_physical_stats(DB_ID(N'YourDatabaseName'),
                                    OBJECT_ID(N'dbo.YourTableName'),
                                    NULL, NULL, 'LIMITED') AS indexstats
JOIN sys.tables dbtables 
    ON dbtables.[object_id] = indexstats.[object_id]
JOIN sys.schemas dbschemas 
    ON dbtables.[schema_id] = dbschemas.[schema_id]
JOIN sys.indexes AS dbindexes 
    ON dbindexes.[object_id] = indexstats.[object_id]
    AND indexstats.index_id = dbindexes.index_id
WHERE dbindexes.[name] = N'YourIndexName'
ORDER BY indexstats.avg_fragmentation_in_percent DESC;