Procedure will check if full text calalog exists in the database and will attempt to drop the full text catalog and all of its indexes.

NOTE: SQL Server only functionality

Arguments

  • v_Catalog_Name – the name of the full text catalog, SYSNAME
  • v_Database_Name – the name of the database wherer full text catalog is created, SYSNAME
  • v_Drop_All_Indexes – when set to 1 this procedure will drop all full text indexes that exist in the specified catalog, BIT. Default value is 0

 

Examples

  SQL Server

      EXEC DBTD_DROP_FULLTEXT_CATALOG_IF_EXISTS 'TEST_FULLTEXT_CATALOG', 'MyDatabase', 1

 

See Also