Show TOC

Copying or Replicating a Column from Another TableLocate this document in the navigation structure

You can reuse existing columns from other tables by copying or replicating them using the tools on the table property sheet Columns tab or by drag and drop. If your table already contains a column with the same name or code as the copied column, the copied column is renamed.

Context

Copying a column creates a simple copy that you can modify as you wish. Replicating a column creates a synchronized copy which remains synchronized with any changes made to the original column (see Core Features Guide > Linking and Synchronizing Models > Shortcuts and Replicas).

Procedure

  1. Open the property sheet of the table you want to copy or replicate the columns to, and click the Columns tab.
  2. Click the Add Columns or Replicate Columns 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 to copy or replicate them to the table.
  4. Click OK to close the table property sheet and return to your model.
    Note To copy or replicate a column from one table to another in the diagram or browser, select the column in the table symbol or its Browser entry, and then right-click and hold while dragging the column to over the second table symbol or its Browser entry. Release and select Copy Here or Replicate Here.