Tag: Full Text Search

How to view index words and count of full text catalog

SELECT * FROM sys.dm_fts_index_keywords(db_id(‘databasename’), object_id(‘tablename’))

SELECT * FROM sys.dm_fts_index_keywords_by_document(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))

SELECT * FROM sys.dm_fts_index_keywords_by_property(db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))

SELECT * FROM sys.dm_fts_parser((db_id(‘AdventureWorks2012’), object_id(‘Production.Product’))