You can copy a column from one table and add it to another table. If the table already contains a column with the same name or code as the copied column, the copied column is renamed. For example, the column PUB_ID is renamed PUB_ID2 when it is copied to a table which already contains a column PUB_ID.
-
Double-click a table to open its property sheet, and click the Columns tab.
-
Click the Add Columns tool to open a selection box listing the columns attached to all other tables in the model.

-
Select one or more columns in the list and then click OK.
The copied columns appear in the list of columns for the current table.
-
Click OK.