| title | sys.fulltext_semantic_languages (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.fulltext_semantic_languages (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.reviewer | mikeray | ||||
| ms.date | 06/10/2016 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!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