RemoveFullTextCatalogs Method

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.

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

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.

Applies To:

See Also

Reference