Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Partitioning the Customers table in the Contacts example

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

CREATE PUBLICATION SalesRepData (
   TABLE SalesReps
   TABLE Customers SUBSCRIBE BY rep_key
)