When you want to destroy the ATG Merchandising tables and you have both ATG Merchandising and ATG Business Commerce, first destroy the ATG Merchandising tables that support ATG Business Commerce, as described in this section, and then destroy the core ATG Merchandising tables, as described in Destroying Versioned Core Commerce Tables.
To destroy ATG Merchandising tables that support ATG Business Commerce, run the drop_b2bcommerce_versioned_ddl.sql script located in the following directory:
<ATG9dir>/B2BCommerce/Versioned/sql/install/database-vendor
The drop_b2bcommerce_versioned_ddl.sql script executes subscripts in a particular order to destroy the tables used by ATG Merchandising and ATG Business Commerce.
