Returns information about the content of a full-text index for the specified table.
sys.dm_fts_index_keywords is a dynamic management function.
To view lower-level full-text index information, use the sys.dm_fts_index_keywords_by_document dynamic management function at the document level.
The hexadecimal representation of the keyword stored inside the full-text index.
OxFF represents the special character that indicates the end of a file or dataset.
The human-readable format of the keyword. This format is derived from the hexadecimal format.
The display_term value for OxFF is "END OF FILE."
ID of the column from which the current keyword was full-text indexed.
Number of documents or rows containing the current term.
The information returned by sys.dm_fts_index_keywords is useful for finding out the following, among other things:
Whether a keyword is part of the full-text index.
How many documents or rows contain a given keyword.
The most common keyword in the full-text index:
document_count of each keyword_value compared to the total document_count, the document count of 0xFF.
Typically, common keywords are likely to be appropriate to declare as stopwords.
A. Displaying high-level full-text index content
The following example displays information about the high-level content of the full-text index in the HumanResources.JobCandidate table of the AdventureWorks sample database. .
SELECT * FROM sys.dm_fts_index_keywords(db_id('AdventureWorks'), object_id('HumanResources.JobCandidate')) GO