| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.fulltext_semantic_languages (Transact-SQL) |
sys.fulltext_semantic_languages (Transact-SQL) |
rwestMSFT |
randolphwest |
mikeray |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Returns a row for each language whose statistics model is registered with the instance of [!INCLUDEssNoVersion]. When a language model is registered, that language is enabled for semantic indexing.
This catalog view is similar to sys.fulltext_languages (Transact-SQL).
| Column name | Type | Description |
|---|---|---|
| lcid | int | Microsoft Windows locale identifier (LCID) for the language. |
| name | sysname | Is either the value of the alias in sys.syslanguages (Transact-SQL) corresponding to the value of lcid, or the string representation of the numeric LCID. |
For more information, see Install and Configure Semantic Search.
For more information about the semantic language statistics database that is installed to support semantic indexing, query the catalog view sys.fulltext_semantic_language_statistics_database (Transact-SQL).
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.
The following example shows how to query sys.fulltext_semantic_languages to get information about all the language models registered for semantic indexing on the current instance of [!INCLUDEssNoVersion].
SELECT * FROM sys.fulltext_semantic_languages;
GO