ATG Merchandising User Guide

When you destroy database tables, you need to destroy them in the opposite order you used for creating them. If you want to remove all tables set up for ATG Merchandising and ATG Business Commerce, for example, you would destroy first the versioned Business Commerce tables, then the versioned core Commerce tables, followed by the ATG Content Administration tables and the ATG Adaptive Scenario Engine tables.

This section includes the following subsections:

Destroying Versioned Custom Catalog Tables With Search Support

In order 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 union of ATG Merchandising, ATG Business Commerce, and ATG Search run the drop_dcs_search_customcatalog_versioned_ddl.sql script in the following directory:

<Atg2007.3dir>/DCS/Search/CustomCatalogs/Versioned/sql/install/
database-vendor

The drop_dcs_search_customcatalog_versioned_ddl.sql script executes subscripts in a particular order to destroy the tables that support the union of ATG Merchandising, ATG Business Commerce, and ATG Search.

Destroying Versioned Search Tables

In order to destroy tables for ATG Merchandising, ATG Search, and core Commerce, you need to destroy two sets of tables.

First of all, destroy the tables that support the union of ATG Merchandising, core Commerce, and ATG Search, run the drop_dcs_search_versioned_ddl.sql script in the following directory:

<Atg2007.3dir>/DCS/Search/Versioned/sql/install/database-vendor

The drop_dcs_search_versioned_ddl.sql script executes subscripts in a particular order to destroy the tables that support the union of ATG Merchandising, core Commerce, and ATG Search.

Secondly, destroy the tables that support the union of ATG Merchandising and ATG Search, run the drop_versioned_refinement_ddl.sql script in the following directory:

<Atg2007.3dir>/DAF/Search/Versioned/sql/uninstall/database-vendor

The drop_versioned_refinement_ddl.sql script executes subscripts in a particular order to destroy the tables that support the union of ATG Merchandising and ATG Search.

Next, remove the versioned Commerce tables, beginning with the Business Commerce tables or Custom Catalogs tables, if you installed them, then move onto the core Commerce tables, described in the sections that follow.

Destroying Versioned Business Commerce Tables

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 specifically support ATG Business Commerce and then 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 in the following directory:

<ATG2006.3dir>/B2BCommerce/Versioned/sql/uninstall/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.

Destroying Custom Catalogs Tables

If you created custom catalogs tables by running a script specifically for this purpose because you wanted to run the custom catalogs without Business Commerce, you can destroy those tables using the drop_versioned_custom_catalog_ddl.sql script in the following directory:

<Atg2007.3dir>/DCS/CustomCatalogs/Versioned/sql/uninstall/database-vendor

If you use custom catalogs with Business Commerce, following the steps in the prior section will destroy custom catalog tables along with all other Business Commerce tables.

Next, follow the instructions to remove versioned core commerce tables as described in Destroying Versioned Core Commerce Tables.

Destroying Versioned Core Commerce Tables

If you created tables for core ATG Merchandising, you can destroy them using the drop_dcs_versioned_ddl.sql script in the following directory:

The drop_dcs_versioned_ddl.sql script executes subscripts in a particular order to destroy the tables used by core ATG Merchandising as well as ATG Commerce. For a description of the ATG Commerce tables dropped by this script, see the Configuring and Populating a Production Database chapter of the ATG Commerce Programming Guide.

All versioned subscripts are described in the table below and located in following directory. If necessary, you can run the subscripts individually: