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 remains synchronized with
any changes made to the original column (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 to, 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.