SELECT t.name AS TableName,
       c.name AS FTCatalogName
FROM sys.tables t
    JOIN sys.fulltext_indexes i
        ON t.object_id = i.object_id
    JOIN sys.fulltext_catalogs c
        ON i.fulltext_catalog_id = c.fulltext_catalog_id;

SELECT cat.name,
       FORMAT(FULLTEXTCATALOGPROPERTY(cat.name, 'ItemCount'), '#,###') AS [RowCount],
       FULLTEXTCATALOGPROPERTY(cat.name, 'IndexSize') AS [IndexSize(MB)],
       FULLTEXTCATALOGPROPERTY(cat.name, 'MergeStatus') AS [MergeStatus],
       FULLTEXTCATALOGPROPERTY(cat.name, 'PopulateCompletionAge') AS [PopulateCompletionAge],
       FULLTEXTCATALOGPROPERTY(cat.name, 'PopulateStatus') AS [PopulateStatus],
       FULLTEXTCATALOGPROPERTY(cat.name, 'ImportStatus') AS [ImportStatus]
FROM sys.fulltext_catalogs AS cat

SELECT t.name AS TableName,
       s.name AS SchemaName,
       FORMAT(p.rows, '#,###') AS RowCounts,
       SUM(a.total_pages) * 8 AS TotalSpaceKB,
       CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
       SUM(a.used_pages) * 8 AS UsedSpaceKB,
       CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
       (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
       CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM sys.tables t
    INNER JOIN sys.indexes i
        ON t.object_id = i.object_id
    INNER JOIN sys.partitions p
        ON i.object_id = p.object_id
           AND i.index_id = p.index_id
    INNER JOIN sys.allocation_units a
        ON p.partition_id = a.container_id
    LEFT OUTER JOIN sys.schemas s
        ON t.schema_id = s.schema_id
GROUP BY t.name,
         s.name,
         p.rows;