In order to destroy tables for ATG Merchandising, ATG Search, and core ATG Commerce, you need to destroy two sets of tables, as follows:
To destroy the tables that support the combination of ATG Merchandising, core ATG Commerce, and ATG Search, run the
drop_dcs_search_versioned_ddl.sql
script located in the following directory:<ATG9dir>/DCS/Search/Versioned/sql/install/
database-vendor
The
drop_dcs_search_versioned_ddl.sql
script destroys the tables by executing subscripts in a particular order.To destroy the tables that support the combination of ATG Merchandising and ATG Search, run the
drop_versioned_refinement_ddl.sql
script located in the following directory:<ATG9dir>/DAF/Search/Versioned/sql/uninstall/
database-vendor
The
drop_versioned_refinement_ddl.sql
script destroys the tables by executing subscripts in a particular order.
Next, remove the versioned commerce tables:
If you installed the ATG Business Commerce tables or Custom Catalog tables, begin by removing those tables, as described in Destroying Versioned Business Commerce Tables and Destroying Versioned Custom Catalog Tables with Search Support.
Remove the core ATG Commerce tables, as described in Destroying Versioned Core Commerce Tables.