Change the Specified Columns

Learn how to add or change a column for a replication definition such as, adding or dropping columns and primary keys, altering column datatypes, and specifying a replicate column name that is different from the primary column name.

• Adding a Column to a Replication Definition
  Learn to add a column to a replication definition.
• Drop a Column from a Replication Definition
  Learn to drop a column from a replication definition.
• Dropping a Searchable Column
  Learn how to drop a searchable column from a replication definition.
• Add or Drop Primary Keys
  Learn how to add or drop primary keys. Replication Server depends on primary keys to find the correct rows at the replicate or standby table.
• Alter Column Datatypes
  There are several rules and restrictions for altering column datatypes.
• Provide a Different Replicate Column Name
  Learn how to specify a replicate column name that is different from the primary column name.