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
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. |
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.
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)
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