| title | Full-Text Search and Semantic Search Stored Procedures (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 0d185a16-2b16-4958-884f-efe675e2e551 | ||||
| author | MikeRayMSFT | ||||
| ms.author | mikeray |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
[!INCLUDEssNoVersion] supports the following system stored procedures that are used to implement and query full-text indexes and semantic indexes.
sp_fulltext_catalog
Creates and drops a full-text catalog, and starts and stops the indexing action for a catalog. Multiple full-text catalogs can be created for each database.
[!INCLUDEssNoteDepFutureDontUse] Use CREATE FULLTEXT CATALOG, ALTER FULLTEXT CATALOG, and DROP FULLTEXT CATALOG instead.
sp_fulltext_column
Specifies whether or not a particular column of a table participates in full-text indexing.
[!INCLUDEssNoteDepFutureAvoid] Use ALTER FULLTEXT INDEX instead.
sp_fulltext_database
Has no effect on full-text catalogs in [!INCLUDEssKatmai] and later versions and is supported for backward compatibility only.
[!INCLUDEssNoteDepFutureDontUse]
sp_fulltext_keymappings
Returns mappings between document identifiers (DocIds) and full-text key values.
sp_fulltext_load_thesaurus_file
Parses and loads the data from an updated thesaurus file that corresponds to an LCID and causes recompilation of full-text queries that use the thesaurus.
sp_fulltext_pendingchanges
Returns unprocessed changes, such as pending inserts, updates, and deletes, for a specified table that is using change tracking.
sp_fulltext_service
Changes the server properties of full-text search for SQL Server.
sp_fulltext_table
Marks or unmarks a table for full-text indexing.
[!INCLUDEssNoteDepFutureDontUse] Use CREATE FULLTEXT INDEX, ALTER FULLTEXT INDEX, and DROP FULLTEXT INDEX instead.
sp_help_fulltext_catalog_components
Returns a list of all components (filters, word-breakers, and protocol handlers), used for all full-text catalogs in the current database.
[!INCLUDEssNoteDepFutureDontUse]
sp_help_fulltext_catalogs
Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_catalogs catalog view instead.
sp_help_fulltext_catalogs_cursor
Uses a cursor to return the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_catalogs catalog view instead.
sp_help_fulltext_columns
Returns the columns designated for full-text indexing.
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_index_columns catalog view instead.
sp_help_fulltext_columns_cursor
Uses a cursor to return the columns designated for full-text indexing.
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_index_columns catalog view instead.
sp_help_fulltext_system_components
Returns information for the registered word-breakers, filter, and protocol handlers, as well as a list of identifiers of databases and full-text catalogs that have used a specified component.
sp_help_fulltext_tables
Returns a list of tables that are registered for full-text indexing.
sp_help_fulltext_tables_cursor
Returns a list of tables that are registered for full-text indexing.
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_indexes catalog view instead.
sp_fulltext_semantic_register_language_statistics_db (Transact-SQL)
Registers a pre-populated Semantic Language Statistics database in the current instance of [!INCLUDEssNoVersion].
sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)
Unregisters an existing Semantic Language Statistics database from the current instance of [!INCLUDEssNoVersion] and deletes any associated metadata.
Full-Text Search and Semantic Search Catalog Views (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)
System Stored Procedures (Transact-SQL)
Full-Text Search