sys.fulltext_semantic_languages (Transact-SQL)
Applies to: SQL Server
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.
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 SQL Server.
SELECT * FROM sys.fulltext_semantic_languages;
GO