Adding a column, index, foreign key, constraint, or trigger

You can use the Data Model Editor to add columns, indexes, foreign keys, constraints, and triggers to the model of a table.
To add a column, index, foreign key, constraint, or trigger to a table, complete the following steps:
  1. Open the model that contains the table in the Data Model Editor and find the table to be changed.
  2. Start of changeRight-click the table to be changed, select New and then select the element to add from the menu. A new element is added to the table, and it is displayed under the appropriate Relationship category in the Data Model Editor.End of change
You can now view the added element in the Properties view and then select various options to rename and define the added element.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.