freetextstopwords Table (44)

Here are the words that can be excluded from Free Text Search by using the FreeTextAdmin. The words that appear here will not be found in FreeTextWords and typically include “are”, “this”, “that”, and so on - words that occur frequently, but are not useful for searching. The more (good) stop words you have, the smaller the index will be.

Fields

NameDescriptionTypeNull
freetextwords_idPrimary keyPK
wordStop word, not to be indexedString(19)

freetextstopwords table relationship diagram

Indexes

FieldsTypesDescription
freetextwords_idPKUnique
wordString(19)Clustered

Replication Flags

  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user’s Role.