Full-Text Search and Semantic Search stored procedures (Transact-SQL)

Applies to: SQL Server

SQL Server supports the following system stored procedures that are used to implement and query full-text indexes and semantic indexes.

Full-Text Search stored procedures

• 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER FULLTEXT INDEX instead.

• sp_fulltext_database

  Has no effect on full-text catalogs in SQL Server 2008 (10.0.x) and later versions and is supported for backward compatibility only.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

• 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

• sp_help_fulltext_catalogs

  Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sys.fulltext_catalogs catalog view instead.

• sp_help_fulltext_columns

  Returns the columns designated for full-text indexing.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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.

  This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sys.fulltext_indexes catalog view instead.

Semantic Search stored procedures

• sp_fulltext_semantic_register_language_statistics_db

  Registers a pre-populated Semantic Language Statistics database in the current instance of SQL Server.

• sp_fulltext_semantic_unregister_language_statistics_db

  Unregisters an existing Semantic Language Statistics database from the current instance of SQL Server and deletes any associated metadata.

Related content

• Full-Text Search and Semantic Search Catalog Views (Transact-SQL)
• Full-Text and Semantic Search Dynamic Management Views - Functions
• System stored procedures (Transact-SQL)
• Full-Text Search