TSQL - Full text search useful queries

-- Languanges

select

      *

from

      sys.fulltext_languages

order by

      name

;

-- Catalogs

select

      *

from

      sys.fulltext_catalogs

;

-- Indexes

select

      *

from

      sys.fulltext_indexes

;

-- Index browsing

select

      *

from

      sys.dm_fts_index_keywords(

            DB_ID('DATABASE_NAME_HERE')

            , OBJECT_ID('TABLE_NAME_HERE')

      ) as V1

where

      display_term <> 'END OF FILE'

;