Edit

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

  • Article

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

Related content