RemoveFullTextCatalogs Method

SQL-DMO

RemoveFullTextCatalogs Method

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

Applies To

Database Object

Syntax

object.RemoveFullTextCatalogs( )

Parts

object

Expression that evaluates to an object in the Applies To list

Prototype (C/C++)

HRESULT RemoveFullTextCatalogs();

Remarks

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.

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