text: SELECT   dbschemas.name AS 'Schema'
          ,dbtables.name AS 'Table'
          ,dbindexes.name AS 'Index'
          ,indexstats.alloc_unit_type_desc
          ,indexstats.avg_fragmentation_in_percent
          ,indexstats.page_count
  FROM     sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) AS indexstats
  INNER JOIN sys.tables dbtables ON dbtables.object_id = indexstats.object_id
  INNER JOIN sys.schemas dbschemas ON dbtables.schema_id = dbschemas.schema_id
  INNER JOIN sys.indexes AS dbindexes ON dbindexes.object_id = indexstats.object_id
                                         AND indexstats.index_id = dbindexes.index_id
  WHERE    indexstats.database_id = DB_ID()
  AND dbschemas.name = 'prod'
  AND dbtables.name = 'tNexus'
  ORDER BY indexstats.avg_fragmentation_in_percent DESC
  