Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
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
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.
Related content
- System 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)