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.
- Open the property sheet of the table you want to copy or
replicate the columns too, and click the Columns
tab.
- Click the Add Columns or
Replicate Columns 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 to copy or replicate them to the table.
- 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.