Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Drops a full-text stoplist from the database in SQL Server.
Transact-SQL syntax conventions
Important
CREATE FULLTEXT STOPLIST is supported only for compatibility level 100 and higher. For compatibility levels 80 and 90, the system stoplist is always assigned to the database.
DROP FULLTEXT STOPLIST stoplist_name
;
stoplist_name
Is the name of the full-text stoplist to drop from the database.
DROP FULLTEXT STOPLIST fails if any full-text indexes refer to the full-text stoplist being dropped.
To drop a stoplist requires having DROP permission on the stoplist or membership in the db_owner or db_ddladmin fixed database roles.
The following example drops a full-text stoplist named myStoplist
.
DROP FULLTEXT STOPLIST myStoplist;
ALTER FULLTEXT STOPLIST (Transact-SQL)
CREATE FULLTEXT STOPLIST (Transact-SQL)
sys.fulltext_stoplists (Transact-SQL)
sys.fulltext_stopwords (Transact-SQL)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today