sys-fulltext-stopwords-transact-sql.md

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

sys.fulltext_stopwords (Transact-SQL)

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

Contains a row per stopword for all stoplists in the database.

Column name	Data type	Description
stoplist_id	int	ID of the stoplist to which stopword belongs. This ID is unique within the database.
stopword	nvarchar(64)	The term to be considered for a stop-word match.
language	sysname	Is either the value of the alias in sys.fulltext_languages corresponding to the value of the locale identifier (LCID), or is the string representation of the numeric LCID.
language_id	int	LCID used for word breaking.

Permissions

[!INCLUDEssCatViewPerm]

See Also

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