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 |
---|---|
| Destroys the tables for the ATG Business Commerce order repository extensions |
| Destroys the tables for the ATG Business Commerce product catalog extensions |
| Destroys the views for reporting on ATG Business Commerce |
| Destroys the tables for the ATG Business Commerce profile extensions |
| Destroys the tables for the ATG Business Commerce contracts repository |
| Destroys the tables for the ATG Business Commerce invoice repository |
| 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 |
---|---|
| Destroys tables for the Motorprise profile extensions for authorization |
| Destroys tables for the Motorprise custom catalog extensions |
| Destroys tables for the Motorprise profile extensions for order details |
| Destroys tables for the Motorprise product catalog extensions for German content |
| Destroys tables for the Motorprise product catalog extensions for Japanese content |