Copying or Replicating a Column from Another Table

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.

Copying a column creates a simple copy that you can modify as you wish. Replicating a column creates a synchronized copy which will have cascaded any changes you make to the original column. For detailed information about working with replicas, see Core Features Guide > Linking and Synchronizing Models > Shortcuts and Replicas.
  1. Open the property sheet of the table you want to copy or replicate the columns too, 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.