Export (0) Print
Expand All

Full-Text Search and Semantic Search Catalog Views (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).

This section describes the catalog views that provide information about full-text indexes and semantic indexes.

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 (Transact-SQL)

Contains a row for each search property contained by any search property list on the current database.

sys.registered_search_property_lists (Transact-SQL)

Contains a row for each search property list on the current database.

sys.fulltext_semantic_language_statistics_database (Transact-SQL)

Returns a row about the semantic language statistics database installed on the current instance of SQL Server.

sys.fulltext_semantic_languages (Transact-SQL)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft