semantic-search-ddl-functions-stored-procedures-and-views.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Semantic Search DDL, functions, stored procedures, & views	Semantic Search DDL, Functions, Stored Procedures, and Views	rwestMSFT	randolphwest	mikeray	03/20/2017	sql	search	conceptual	semantic search [SQL Server], database objects

Semantic Search DDL, Functions, Stored Procedures, and Views

[!INCLUDE SQL Server] Lists the Transact-SQL statements and the database objects that support statistical semantic search in [!INCLUDEssNoVersion].

For the list of statements and database objects that support full-text search, see Full-Text Search DDL, Functions, Stored Procedures, and Views.

Data Definition Language (DDL) Statements

Object	More Information
ALTER FULLTEXT INDEX (Transact-SQL)	Enable Semantic Search on Tables and Columns
CREATE FULLTEXT INDEX (Transact-SQL)	Enable Semantic Search on Tables and Columns

System Functions

Object	More Information
semantickeyphrasetable (Transact-SQL)	Find Key Phrases in Documents with Semantic Search
semanticsimilaritydetailstable (Transact-SQL)	Find Similar and Related Documents with Semantic Search
semanticsimilaritytable (Transact-SQL)	Find Similar and Related Documents with Semantic Search

System Metadata Functions

Object	More Information
COLUMNPROPERTY (Transact-SQL)	Enable Semantic Search on Tables and Columns
DATABASEPROPERTYEX (Transact-SQL)	Enable Semantic Search on Tables and Columns
FULLTEXTCATALOGPROPERTY (Transact-SQL)	Manage and Monitor Semantic Search
INDEXPROPERTY (Transact-SQL)	Manage and Monitor Semantic Search
OBJECTPROPERTYEX (Transact-SQL)	Enable Semantic Search on Tables and Columns
SERVERPROPERTY (Transact-SQL)	Install and Configure Semantic Search

System Stored Procedures

Object	More Information
sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)	Install and Configure Semantic Search
sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)	Install and Configure Semantic Search

Catalog Views

Object	More Information
sys.fulltext_index_columns (Transact-SQL)	Manage and Monitor Semantic Search
sys.fulltext_semantic_language_statistics_database (Transact-SQL)	Install and Configure Semantic Search
sys.fulltext_semantic_languages (Transact-SQL)	Install and Configure Semantic Search

Dynamic Management Views

Object	More Information
sys.dm_db_fts_index_physical_stats (Transact-SQL)	Manage and Monitor Semantic Search
sys.dm_fts_index_population (Transact-SQL)	Manage and Monitor Semantic Search
sys.dm_fts_semantic_similarity_population (Transact-SQL)	Manage and Monitor Semantic Search

See Also

Manage and Monitor Semantic Search