| title | sys.fulltext_semantic_languages (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | b42a85e6-1db9-4a22-8a70-014574c95198 | ||||
| author | pmasl | ||||
| ms.author | pelopes | ||||
| ms.reviewer | mikeray |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
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