Chapter 3 Building Physical Diagrams

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.

Steps To copy a column to another table:

  1. Double-click a table in the diagram to display the table property sheet.
  2. Click the Columns page.

    The Columns page appears.
  3. Click the Add Columns tool.

    A selection box appears. It lists columns attached to all other tables in the model.
  4. Select one or more columns in the list.
  5. Click OK.

    The copied columns appear in the list of columns for the current table.
  6. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.