7. Maintaining the Replicator : Maintenance of Replicated Tables and Databases : Using SQL Statements on Replicated Tables : Modify to Truncated Statement
 
Share this page                  
Modify to Truncated Statement
The SQL statement MODIFY TO TRUNCATED bypasses change recording and, therefore, must not be used with replicated tables. If you are deleting in bulk from a replicated table and the deletion of records is expected to be replicated throughout the replication system, use the DELETE statement instead of the MODIFY TO TRUNCATED statement.
Use a MODIFY TO TRUNCATED statement if you are completely cleaning out a table. In this case, issue MODIFY TO TRUNCATED on the table to be cleared in every database in the replicated system. It is also recommended that you run the Arcclean utility at this time.