Semantic Search DDL, Functions, Stored Procedures, and Views

  • Article

Lists the Transact-SQL statements and the database objects that support statistical semantic search in SQL Server.

The Status column in the following tables indicates whether the item is new in SQL Server 2012, or was present in previous versions of SQL Server but has been changed in SQL Server 2012 to support semantic search.

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

In This Topic

  • Transact-SQL Data Definition Language (DDL) Statements

  • System Functions

  • System Metadata Functions

  • System Stored Procedures

  • System Views – Catalog Views

  • System Views – Dynamic Management Views

Transact-SQL Data Definition Language (DDL) Statements

Object

Status

More Information

ALTER FULLTEXT INDEX (Transact-SQL)

Changed

Enable Semantic Search on Tables and Columns

CREATE FULLTEXT INDEX (Transact-SQL)

Changed

Enable Semantic Search on Tables and Columns

[TOP]

System Functions

Object

Status

More Information

semantickeyphrasetable (Transact-SQL)

Added

Find Key Phrases in Documents with Semantic Search

semanticsimilaritydetailstable (Transact-SQL)

Added

Find Similar and Related Documents with Semantic Search

semanticsimilaritytable (Transact-SQL)

Added

Find Similar and Related Documents with Semantic Search

[TOP]

System Metadata Functions

Object

Status

More Information

COLUMNPROPERTY (Transact-SQL)

Changed

Enable Semantic Search on Tables and Columns

DATABASEPROPERTYEX (Transact-SQL)

Changed

Enable Semantic Search on Tables and Columns

FULLTEXTCATALOGPROPERTY (Transact-SQL)

Changed

Manage and Monitor Semantic Search

INDEXPROPERTY (Transact-SQL)

Changed

Manage and Monitor Semantic Search

OBJECTPROPERTYEX (Transact-SQL)

Changed

Enable Semantic Search on Tables and Columns

SERVERPROPERTY (Transact-SQL)

Changed

Install and Configure Semantic Search

[TOP]

System Stored Procedures

Object

Status

More Information

sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)

Added

Install and Configure Semantic Search

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)

Added

Install and Configure Semantic Search

[TOP]

System Views – Catalog Views

Object

Status

More Information

sys.fulltext_index_columns (Transact-SQL)

Changed

Manage and Monitor Semantic Search

sys.fulltext_semantic_language_statistics_database (Transact-SQL)

Added

Install and Configure Semantic Search

sys.fulltext_semantic_languages (Transact-SQL)

Added

Install and Configure Semantic Search

[TOP]

System Views – Dynamic Management Views

Object

Status

More Information

sys.dm_db_fts_index_physical_stats (Transact-SQL)

Added

Manage and Monitor Semantic Search

sys.dm_fts_index_population (Transact-SQL)

Changed

Manage and Monitor Semantic Search

sys.dm_fts_semantic_similarity_population (Transact-SQL)

Added

Manage and Monitor Semantic Search

[TOP]

See Also

Concepts

Manage and Monitor Semantic Search