Semantic Search Catalog Views

Se more view version maps here: Microsoft Sql System View Version Maps

• sys.fulltext_semantic_language_statistics_database
• sys.fulltext_semantic_languages

sys.fulltext_semantic_language_statistics_database

Returns a row about the semantic language statistics database installed on the current instance of SQL Server. You can query this view to find out about the semantic language statistics component required for semantic processing.

Column name	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	Type	Description
database_id				•	int	ID of the database, unique within an instance of SQL Server.
register_date				•	datetime	Date the database was registered for semantic processing.
registered_by				•	int	ID of the server principal that registered the database for semantic processing.
version				•	nvarchar(128)	The latest version information specific to the semantic language statistics database.

TSQL

Sql 2012
SELECT [database_id], [register_date], [registered_by], [version] FROM sys.fulltext_semantic_language_statistics_database

Back to Top

---

sys.fulltext_semantic_languages

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)1.

Column name	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	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)2 corresponding to the value of lcid, or the string representation of the numeric LCID.

TSQL

Sql 2012
SELECT [lcid], [name] FROM sys.fulltext_semantic_languages

Back to Top

---