Destroying Tables for ATG Business Commerce

To destroy all ATG Business Commerce tables, destroy first the core ATG Commerce tables, as described in Destroying Tables for Core ATG Commerce and then run the ATG Business Commerce script appropriate for your product suite.

Note: While dropping these tables you may see error messages indicating that six views could not be removed. This is not an error. During the installation of ATG Business Commerce, six views that are created by ATG Consumer Commerce are removed because they are not applicable in ATG Business Commerce. The views involved are listed below:

  • View DRPT_PRODUCTS

  • View DRPT_CATEGORY

  • View DRPTW_CAT_SALES

  • View DRPTM_CAT_SALES

  • View DRPTQ_CAT_SALES

  • View DRPTA_CAT_SALES

To destroy all ATG Business Commerce tables, destroy the core ATG Commerce tables, as described in Destroying Tables for Core ATG Commerce, and then run the drop_b2bcommerce_ddl.sql script from the following directory:

<ATG2007.3dir>/B2BCommerce/sql/install/database-vendor

The drop_b2bcommerce_ddl.sql script is derived from subscripts described in Destroying Tables for Core ATG Commerce as well as subscripts listed in the table below. If necessary, you can run each subscript individually from the following directory:

<ATG2007.3dir>/B2BCommerce/sql/uninstall/database-vendor

Script name

Purpose

drop_b2b_order_ddl.sql

Destroys the tables for the ATG Business Commerce order repository extensions

drop_b2b_product_catalog_ddl.sql

Destroys the tables for the ATG Business Commerce product catalog extensions

drop_b2b_reporting_views.sql

Destroys the views for reporting on ATG Business Commerce

drop_b2b_user_ddl.sql

Destroys the tables for the ATG Business Commerce profile extensions

drop_contracts_ddl.sql

Destroys the tables for the ATG Business Commerce contracts repository

drop_invoice_ddl.sql

Destroys the tables for the ATG Business Commerce invoice repository

drop_organization_ddl.sql

Destroys the tables for the ATG Business Commerce organization extensions

Destroying Motorprise Reference Application Tables

You can destroy the database tables for ATG Adaptive Scenario Engine, core ATG Commerce, ATG Business Commerce, and the Motorprise reference application by running a single script, drop_motorpriseall_ddl.sql, from the following directory:

<ATG2007.3dir>/MotorpriseJSP/sql/install/database-vendor

Alternatively, to destroy just the database tables for the Motorprise reference application, run the drop_motorprise_ddl.sql script from the same directory.

The drop_motoprise_ddl.sql script is derived from the Destroying Tables for ATG Business Commerce as well as subscripts listed in the table below. If necessary, you can run each subscript individually from the following directory:

<ATG2007.3dir>/MotorpriseJSP/sql/uninstall/database-vendor

Script name

Purpose

drop_b2b_auth_cc_ddl.sql

Destroys tables for the Motorprise profile extensions for authorization

drop_b2b_custom_catalog_ddl.sql

Destroys tables for the Motorprise custom catalog extensions

drop_b2b_user_orddet_ddl.sql

Destroys tables for the Motorprise profile extensions for order details

drop_german_catalog_ddl.sql

Destroys tables for the Motorprise product catalog extensions for German content

drop_japanese_catalog_ddl.sql

Destroys tables for the Motorprise product catalog extensions for Japanese content

 
loading table of contents...