Dropping a Searchable Column

Learn how to drop a searchable column from a replication definition.

Prerequisites

You can drop searchable columns from a replication definition only if they are not used in subscription or article where clause.

Task

Use drop subscription to remove any subscriptions in which you want the where clause to exclude the searchable columns you are dropping.
Use alter replication definition to drop the searchable column. For example:
```
alter replication definition publishers_rep
drop searchable columns zip
```
This example removes the zip searchable column from the publishers_rep replication definition.

See Replication Server Reference Manual > Replication Server Commands > alter replication definition.
Use create subscription to re-create subscriptions to the altered replication definition.