To destroy tables for ATG Merchandising, ATG Search, and ATG Business Commerce (or Consumer Commerce with custom catalogs), first destroy the tables in this section, then destroy the tables described in Destroying Versioned Core Commerce Tables.
To destroy tables that support the combination of ATG Merchandising, ATG Business Commerce, and ATG Search, run the drop_dcs_search_customcatalog_versioned_ddl.sql script located in the following directory:
<ATG9dir>/DCS/Search/CustomCatalogs/Versioned/sql/install/database-vendor
The drop_dcs_search_customcatalog_versioned_ddl.sql script destroys the tables by executing subscripts in a particular order.
