To destroy all core ATG Commerce tables, run the drop_dcs_ddl.sql script from the following directory:

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

The drop_dcs_ddl.sql script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:

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

File Name

Description

drop_claimable_ddl.sql

Destroys the schema for the ATG Commerce Claimable repository

drop_commerce_user.sql

Destroys the tables for the ATG Commerce credit card profile extensions

drop_dcs_mappers.sql

Destroys the table for handling shopping cart events

drop_inventory_ddl.sql

Destroys the tables for the ATG Commerce inventory system

drop_order_ddl.sql

Destroys the tables for the ATG Commerce purchase process

drop_order_markers_ddl.sql

Destroys the tables that contain order markers

drop_priceLists_ddl.sql

Destroys the tables for the ATG Commerce price lists

drop_product_catalog_ddl.sql

Destroys the tables for the ATG Commerce product catalog

drop_promotion_ddl.sql

Destroys the tables for the ATG Commerce promotions

drop_reporting_views.sql

Destroys the views for reporting

drop_reporting_views1.sql

Destroys additional views for reporting

drop_reporting_views2.sql

Destroys additional views for reporting

drop_reporting_views3.sql

Destroys additional views for reporting

drop_user_giftlist_ddl.sql

Destroys the tables for the ATG Commerce Giftlist Services

drop_user_promotion_ddl.sql

Destroys the tables for the ATG Commerce promotions profile extensions

 
loading table of contents...