语义搜索 DDL、函数、存储过程和视图Semantic Search DDL, Functions, Stored Procedures, and Views

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

列出用于在 SQL ServerSQL Server中支持统计语义搜索的 Transact-SQL 语句和数据库对象。Lists the Transact-SQL statements and the database objects that support statistical semantic search in SQL ServerSQL Server.

有关支持全文搜索的语句和数据库对象的列表,请参阅 全文搜索 DDL、函数、存储过程和视图For the list of statements and database objects that support full-text search, see Full-Text Search DDL, Functions, Stored Procedures, and Views.

数据定义语言 (DDL) 语句Data Definition Language (DDL) Statements

ObjectObject 详细信息More Information
ALTER FULLTEXT INDEX (Transact-SQL)ALTER FULLTEXT INDEX (Transact-SQL) 对表和列启用语义搜索Enable Semantic Search on Tables and Columns
CREATE FULLTEXT INDEX (Transact-SQL)CREATE FULLTEXT INDEX (Transact-SQL) 对表和列启用语义搜索Enable Semantic Search on Tables and Columns

系统函数System Functions

ObjectObject 详细信息More Information
semantickeyphrasetable (Transact-SQL)semantickeyphrasetable (Transact-SQL) 使用语义搜索查找文档中的关键短语Find Key Phrases in Documents with Semantic Search
semanticsimilaritydetailstable (Transact-SQL)semanticsimilaritydetailstable (Transact-SQL) 使用语义搜索来查找相似和相关文档Find Similar and Related Documents with Semantic Search
semanticsimilaritytable (Transact-SQL)semanticsimilaritytable (Transact-SQL) 使用语义搜索来查找相似和相关文档Find Similar and Related Documents with Semantic Search

系统元数据函数System Metadata Functions

ObjectObject 详细信息More Information
COLUMNPROPERTY (Transact-SQL)COLUMNPROPERTY (Transact-SQL) 对表和列启用语义搜索Enable Semantic Search on Tables and Columns
DATABASEPROPERTYEX (Transact-SQL)DATABASEPROPERTYEX (Transact-SQL) 对表和列启用语义搜索Enable Semantic Search on Tables and Columns
FULLTEXTCATALOGPROPERTY (Transact-SQL)FULLTEXTCATALOGPROPERTY (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search
INDEXPROPERTY (Transact-SQL)INDEXPROPERTY (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search
OBJECTPROPERTYEX (Transact-SQL)OBJECTPROPERTYEX (Transact-SQL) 对表和列启用语义搜索Enable Semantic Search on Tables and Columns
SERVERPROPERTY (Transact-SQL)SERVERPROPERTY (Transact-SQL) 安装和配置语义搜索Install and Configure Semantic Search

系统存储过程System Stored Procedures

ObjectObject 详细信息More Information
sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)sp_fulltext_semantic_register_language_statistics_db (Transact-SQL) 安装和配置语义搜索Install and Configure Semantic Search
sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL) 安装和配置语义搜索Install and Configure Semantic Search

目录视图Catalog Views

ObjectObject 详细信息More Information
sys.fulltext_index_columns (Transact-SQL)sys.fulltext_index_columns (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search
sys.fulltext_semantic_language_statistics_database (Transact-SQL)sys.fulltext_semantic_language_statistics_database (Transact-SQL) 安装和配置语义搜索Install and Configure Semantic Search
sys.fulltext_semantic_languages (Transact-SQL)sys.fulltext_semantic_languages (Transact-SQL) 安装和配置语义搜索Install and Configure Semantic Search

动态管理视图Dynamic Management Views

ObjectObject 详细信息More Information
sys.dm_db_fts_index_physical_stats (Transact-SQL)sys.dm_db_fts_index_physical_stats (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search
sys.dm_fts_index_population (Transact-SQL)sys.dm_fts_index_population (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search
sys.dm_fts_semantic_similarity_population (Transact-SQL)sys.dm_fts_semantic_similarity_population (Transact-SQL) 管理和监视语义搜索Manage and Monitor Semantic Search

另请参阅See Also

管理和监视语义搜索Manage and Monitor Semantic Search