Configuration Guide

Back Next

Removing Staging Tables

To remove a staging table:

Start the Schema Manager.

Acquire a write lock.

In the schema tree, expand the

Base Objects

node, and then expand the node for the base object associated with this staging table.

Right-click the staging table that you want to remove, and then choose

Remove

The Schema Manager prompts you to confirm deletion.

Choose

Yes

The Schema Manager drops the staging table from the

Operational Reference Store

(

Operational Reference Store

), deletes associated control tables, and removes the deleted staging table from the schema tree.