Articles defined for UltraLite, MobiLink and SQL Remote publications use a WHERE clause to define a subset of rows of a table to be included in an article.

The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.

The WHERE Clauses tab is only shown if the publication that contains the articles has a type of log scan.

This tab has the following components:

The following example creates a single-article publication that includes all sales order information for sales rep number 856.

CREATE PUBLICATION pub_orders_samuel_singer
 ( TABLE SalesOrders
     WHERE SalesRepresentative = 856 );

See Publish only some rows using a WHERE clause.

 See also