The properties for a selected subscription are grouped with tabs that set values for related characteristics. Select a subscription, right-click, and select the Properties command to display the Properties dialog. Note that clicking OK in the Properties dialog drops and re-creates the subscription. If you only want to review the properties and do not make changes, click Cancel to dismiss the Properties dialog without re-creating the subscription.
You can create and modify the following subscription properties:
SQL criteria to use in determining which source rows to replicate
information about the destination and how to replicate the data
the CREATE statement that will be executed at the destination to create the target object
SQL processing statements that alter data in the source or destination databases, either immediately before or immediately after replication
which indexes and constraints that are placed on the source object that you want to replicate