Full-Text Search and Semantic Search Stored Procedures (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

Full-Text Search and Semantic Search Stored Procedures (Transact-SQL)

 

Applies To: SQL Server

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 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.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 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 Microsoft 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 and later versions and is supported for backward compatibility only.

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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 Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 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 Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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

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

sp_fulltext_semantic_unregister_language_statistics_db (Transact-SQL)
Unregisters an existing Semantic Language Statistics database from the current instance of SQL Server 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

Community Additions

ADD
Show:
© 2016 Microsoft