Copying a Column to Another Table

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.

1. Double-click a table to open its property sheet, and click the Columns tab.
2. Click the Add Columns tool to open a selection box listing the columns attached to all other tables in the model.
   
   
3. 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.

4. Click OK.