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
This section describes the catalog views that provide information about full-text indexes and semantic indexes.
Full-Text Search catalog views
| Article | Description |
|---|---|
| sys.fulltext_catalogs | Contains a row for each full-text catalog. |
| sys.fulltext_document_types | Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server. |
| sys.fulltext_index_catalog_usages | Returns a row for each full-text catalog to full-text index reference. |
| sys.fulltext_index_columns | Contains a row for each column that is part of a full-text index. |
| sys.fulltext_index_fragments | Contains a row for each full-text index fragment in every table that contains a full-text index. |
| sys.fulltext_indexes | Contains a row per full-text index of a tabular object. |
| sys.fulltext_languages | Contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language. |
| sys.fulltext_stoplists | Contains a row per full-text stoplist in the database. |
| sys.fulltext_stopwords | Contains a row per stopword for all stoplists in the database. |
| sys.fulltext_system_stopwords | Provides access to the system stoplist. |
| sys.registered_search_properties | Contains a row for each search property contained by any search property list on the current database. |
| sys.registered_search_property_lists | Contains a row for each search property list on the current database. |
Semantic search catalog views
| Article | Description |
|---|---|
| sys.fulltext_semantic_language_statistics_database | Returns a row about the semantic language statistics database installed on the current instance of SQL Server. |
| sys.fulltext_semantic_languages | Returns a row for each language whose statistics model is registered with the instance of SQL Server. When a language model is registered, that language is enabled for semantic indexing. |