Example: Truncating _all tables
If the item_mst_all table is corrupt in a system with non-master sites in separate databases, you could use the button on the Update _All Tables form this way:
- Select item_mst_all in Site A and click . This truncates the item_mst_all table in Site A.
- Select item_mst_all in Site B and click . This truncates the item_mst_all table in Site B.
- Select item_mst_all in Site A and click (leave the Disable Replication check box cleared). This adds all of item_mst records where site_ref = 'Site B' to the item_mst_all table in both sites A and B (assuming that site B is replicating item_mst_all table to Site A).
- Select item_mst_all in Site B and click (leave the Disable Replication check box cleared). This adds all of site B's item_mst_all records in both sites A and B.
In this example, either site can have bad data, or both sites can have bad data. The item_mst_all tables in both sites are repopulated entirely from scratch.
Note: The button only truncates if there is an actual
table in the current site. This is true in the master site of a shared environment, or
in a multi-site, multi-database environment. In an environment that has a shared view, a
delete on the current site is performed instead. If you want to perform a delete on
another site, use the delete buttons instead of the button.