RemoveFullTextCatalogs Method

Article
12/15/2008

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The RemoveFullTextCatalogs method drops all Microsoft Search full-text catalogs supporting full-text query on a Microsoft SQL Server database.

Syntaxe

object
.RemoveFullTextCatalogs(
)

Parts

object
Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT RemoveFullTextCatalogs();

Notes

The RemoveFullTextCatalogs method:

Locates all full-text catalogs defined for a database.
Stops population of all full-text catalogs.
Disables full-text indexing on any tables whose indexes are maintained in the full-text-catalogs.
Drops all full-text catalogs.

The method does not disable full-text indexing on the referenced database but removes all data used to configure full-text indexing and all full-text catalogs supporting the indexes.

Remarque :
After using the RemoveFullTextCatalogs method, a database must be configured anew to restore full-text indexing on the database. Use the Rebuild method of the FullTextCatalog object to re-create full-text catalogs as currently configured.