全文檢索搜尋 DDL、函數、預存程序與檢視

列出支援全文檢索搜尋的 Transact-SQL 陳述式和 SQL Server 資料庫物件，包含屬性搜尋功能。

此清單不包含已被取代的物件。

如需支援語意搜尋之資料庫物件的清單，請參閱＜語意搜尋 DDL、函數、預存程序及檢視＞。

本主題內容

• Transact-SQL 資料定義語言 (DDL) 陳述式

• 系統述詞和函數

• 系統中繼資料函數

• 系統預存程序

• 系統檢視表 - 目錄檢視

• 系統檢視表 - 動態管理檢視

Transact-SQL 資料定義語言 (DDL) 陳述式

• CREATE FULLTEXT CATALOG (Transact-SQL)

• CREATE FULLTEXT INDEX (Transact-SQL)

• CREATE FULLTEXT STOPLIST (Transact-SQL)

• CREATE SEARCH PROPERTY LIST (Transact-SQL)

• ALTER FULLTEXT CATALOG (Transact-SQL)

• ALTER FULLTEXT INDEX (Transact-SQL)

• ALTER FULLTEXT STOPLIST (Transact-SQL)

• ALTER SEARCH PROPERTY LIST (Transact-SQL)

• DROP FULLTEXT CATALOG (Transact-SQL)

• DROP FULLTEXT INDEX (Transact-SQL)

• DROP FULLTEXT STOPLIST (Transact-SQL)

• DROP SEARCH PROPERTY LIST (Transact-SQL)

[回到頁首]

系統述詞和函數

• CONTAINS (Transact-SQL)

• CONTAINSTABLE (Transact-SQL)

• FREETEXT (Transact-SQL)

• FREETEXTTABLE (Transact-SQL)

[回到頁首]

系統中繼資料函數

• COLUMNPROPERTY (Transact-SQL)

• FULLTEXTCATALOGPROPERTY (Transact-SQL)

• FULLTEXTSERVICEPROPERTY (Transact-SQL)

• INDEXPROPERTY (Transact-SQL)

• OBJECTPROPERTY (Transact-SQL)

• OBJECTPROPERTYEX (Transact-SQL)

• SERVERPROPERTY (Transact-SQL)

[回到頁首]

系統預存程序

• sp_fulltext_keymappings (Transact-SQL)

• sp_fulltext_load_thesaurus_file (Transact-SQL)

• sp_fulltext_pendingchanges (Transact-SQL)

• sp_fulltext_service (Transact-SQL)

• sp_help_fulltext_system_components (Transact-SQL)

[回到頁首]

系統檢視表 - 目錄檢視

• sys.fulltext_catalogs (Transact-SQL)

• sys.fulltext_document_types (Transact-SQL)

• sys.fulltext_index_catalog_usages (Transact-SQL)

• sys.fulltext_index_columns (Transact-SQL)

• sys.fulltext_index_fragments (Transact-SQL)

• sys.fulltext_indexes (Transact-SQL)

• sys.fulltext_languages (Transact-SQL)

• sys.fulltext_stoplists (Transact-SQL)

• sys.fulltext_stopwords (Transact-SQL)

• sys.fulltext_system_stopwords (Transact-SQL)

• sys.registered_search_properties (Transact-SQL)

• sys.registered_search_property_lists (Transact-SQL)

[回到頁首]

系統檢視表 - 動態管理檢視

• sys.dm_fts_active_catalogs (Transact-SQL)

• sys.dm_fts_fdhosts (Transact-SQL)

• sys.dm_fts_index_keywords (Transact-SQL)

• sys.dm_fts_index_keywords_by_document (Transact-SQL)

• sys.dm_fts_index_keywords_by_property (Transact-SQL)

• sys.dm_fts_index_population (Transact-SQL)

• sys.dm_fts_memory_buffers (Transact-SQL)

• sys.dm_fts_memory_pools (Transact-SQL)

• sys.dm_fts_outstanding_batches (Transact-SQL)

• sys.dm_fts_parser (Transact-SQL)

• sys.dm_fts_population_ranges (Transact-SQL)

[回到頁首]