sys.fulltext_system_stopwords (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Provides access to the system stoplist.

Column name Data type Description
stopword nvarchar(64) The term that is considered for a stop-word match.
language_id int Locale identifier (LCID) of the language. This LCID is used for word breaking.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

See Also

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
sys.fulltext_stoplists (Transact-SQL)
sys.fulltext_stopwords (Transact-SQL)
Configure and Manage Stopwords and Stoplists for Full-Text Search