Query:
  1. DECLARE @Database NVARCHAR(128)
  2. DECLARE @Table NVARCHAR(128)
  4. SET @Database = N'MYDATABASE' -- Database
  5. SET @Table = N'dbo.ProposalForm' -- Table
  7. SELECT
  8. I.name,
  9. ROUND(S.avg_fragmentation_in_percent, 2) AS FragmentationPercent
  10. FROM
  11. sys.dm_db_index_physical_stats (DB_ID(@Database), OBJECT_ID(@Table)
  12. , NULL, NULL, NULL) S
  13. INNER JOIN
  14. sys.indexes I
  15. ON
  16. S.object_id = I.object_id
  17. AND
  18. S.index_id = I.index_id
Output: