sys-fulltext-stoplists-transact-sql.md

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

sys.fulltext_stoplists (Transact-SQL)

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

Contains a row per full-text stoplist in the database.

Column name	Data type	Description
stoplist_id	int	ID of the stoplist, unique within the database.
name	sysname	Name of the stoplist.
create_date	datetime	Date that stoplist was created.
modify_date	datetime	Date that stoplist was last modified using any ALTER statement.
Principal_id	int	ID of the database principal that owns the stoplist.

Permissions

[!INCLUDEssCatViewPerm]

See Also

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)
sys.fulltext_system_stopwords (Transact-SQL)
sys.fulltext_stopwords (Transact-SQL)
Configure and Manage Stopwords and Stoplists for Full-Text Search
CREATE FULLTEXT STOPLIST (Transact-SQL)
ALTER FULLTEXT STOPLIST (Transact-SQL)
DROP FULLTEXT STOPLIST (Transact-SQL)