Dropping a Searchable Column

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

1. Use drop subscription to remove any subscriptions in which you want the where clause to exclude the searchable columns you are dropping.
2. 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.

3. Use create subscription to re-create subscriptions to the altered replication definition.