Contents Index The Contact example Partitioning the Contact table in the Contact example

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

Partitioning the Customer table in the Contact example


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

CREATE PUBLICATION SalesRepData (
   TABLE SalesRep
   TABLE Customer SUBSCRIBE BY rep_key
)

Contents Index The Contact example Partitioning the Contact table in the Contact example