A searchable column lets you create subscriptions based on values in the column.
To add and take advantage of a searchable column:
Use drop subscription to remove any subscriptions in which you want the where clause to include the added searchable column. See “Using the drop subscription command”.
Use alter replication definition to add the searchable column. For example:
alter replication definition publishers_rep add searchable columns zip
(This example makes the zip column searchable.)
See alter replication definition in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for more information.
Use create subscription to re-create subscriptions to the altered replication definition. See “Using the create subscription command”.
See “Changing searchable columns” for more information.
