Adding a Searchable Column

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.
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 Replication Server Reference Manual > Replication Server Commands > alter replication definition.
Use create subscription to re-create subscriptions to the altered replication definition.