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.