Adding a column

To add a char column named zip (for zip code information) to the source and destination copies of the publishers table:

Use the Transact-SQL alter table command to add the column to the tables in Adaptive Server. See the Adaptive Server Enterprise Reference Manual for more information.
Use alter replication definition to add the same column to the publishers_rep:
```
alter replication definition publishers_rep
add zip char(10)
```
If the column you added to the destination table has a different name than the source column, enter a command like this:
```
alter replication definition publishers_rep
add zip as rep_zip char(10)
```

See “Adding columns in source and destination tables” and alter replication definition in Chapter 3, “Replication Server Commands” Replication Server Reference Manual for more information.