CREATE FULLTEXT STOPLIST (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Creates a new full-text stoplist in the current database.
Stopwords are managed in databases by using objects called stoplists. A stoplist is a list of stopwords that, when associated with a full-text index, is applied to full-text queries on that index. For more information, see Configure and Manage Stopwords and Stoplists for Full-Text Search.
CREATE FULLTEXT STOPLIST, ALTER FULLTEXT STOPLIST, and DROP FULLTEXT STOPLIST are supported only under compatibility level 100. Under compatibility levels 80 and 90, these statements are not supported. However, under all compatibility levels the system stoplist is automatically associated with new full-text indexes.
Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.
A. Creating a new full-text stoplist
The following example creates a new full-text stoplist named myStoplist.
CREATE FULLTEXT STOPLIST myStoplist; GO
B. Copying a full-text stoplist from an existing full-text stoplist
The following example creates a new full-text stoplist named myStoplist2 by copying an existing AdventureWorks stoplist named Customers.otherStoplist.
CREATE FULLTEXT STOPLIST myStoplist2 FROM AdventureWorks.otherStoplist; GO
C. Copying a full-text stoplist from the system full-text stoplist
The following example creates a new full-text stoplist named myStoplist3 by copying from the system stoplist.
CREATE FULLTEXT STOPLIST myStoplist3 FROM SYSTEM STOPLIST; GO