Contents Index Territory realignment in the Contact example Adding a subscription-list column to the Contact table

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Partitioning tables that do not contain the subscription column

Partitioning the Customer table in the Contact example


The Customer table can be partitioned using the rep_key value as a subscription column. A publication that includes the SalesRep and Customer tables would be as follows:

exec sp_add_remote_table 'SalesRep'
exec sp_add_remote_table 'Customer'
go
exec sp_create_publication 'SalesRepData'
go
exec sp_add_article 'SalesRepData', 'SalesRep'
exec sp_add_article SalesRepData,
         Customer, NULL,
         'rep_key'
go

Contents Index Territory realignment in the Contact example Adding a subscription-list column to the Contact table