User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise

The two tables must have the same columns and data types as table

table_name

Examples

♦ The following statement marks the Customer table for replication, using

default conﬂict resolution:

exec sp_add_remote_table Customer

♦ The following statement marks the Customer table for replication, using a

stored procedure named Customer_Conﬂict to resolve conﬂicts. The old

and remote rows are stored in tables named old_Customer and

remote_Customer, respectively:

exec sp_add_remote_table Customer, Customer_Conflict, old_

Customer, remote_Customer

385