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 located in the following directory:

<ATG9dir>/DCS/Versioned/sql/install/database-vendor

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. If necessary, you can run the subscripts individually from the following directory:

<ATG9dir>/DCS/Versioned/sql/uninstall/database-vendor

Script name

Purpose

drop_versioned_claimable_ddl.sql

Destroys tables that support versioning coupons

drop_versioned_priceLists_ddl.sql

Destroys tables for that support versioning price lists

drop_versioned_product_catalog_ddl.sql

Destroys tables that support versioning products and catalogs

drop_versioned_promotion_ddl.sql

Destroys tables that support versioning promotions

 
loading table of contents...