Deleting columns in a source or destination table

To delete columns in source and destination tables in a warm standby only setup, follow the instructions in “alter table support for warm standby” on page 117 in the Replication Server Administration Guide Volume 2.

To delete columns in source and destination tables that are replicated through subscriptions, use the “Migration procedure”.

NoteIf you drop columns from a table, it is unnecessary to drop those columns from replication definitions unless they are used in a subscription or article where clause. However, the columns need to be dropped from the searchable columns list and the primary key list.

If you drop table columns that are used in a subscription or article where clause, you need to drop the subscription or article, then recreate it.