Skip to content

Latest commit

 

History

History
45 lines (39 loc) · 2.02 KB

sys-fulltext-system-stopwords-transact-sql.md

File metadata and controls

45 lines (39 loc) · 2.02 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.fulltext_system_stopwords (Transact-SQL)
sys.fulltext_system_stopwords (Transact-SQL)
rwestMSFT
randolphwest
mikeray
06/10/2016
sql
system-objects
reference
sys.fulltext_system_stopwords_TSQL
fulltext_system_stopwords
fulltext_system_stopwords_TSQL
sys.fulltext_system_stopwords
stoplists [full-text search]
sys.fulltext_system_stopwords catalog view
full-text search [SQL Server], stopwords
stopwords [full-text search]
TSQL
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.fulltext_system_stopwords (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

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.

Permissions

[!INCLUDEssCatViewPerm]

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