Changing model object properties

You can change the properties of objects in the Data Model Editor by using the Properties View. For example, you can use the Properties view to change the name and attributes of a column in a table or to reorder the columns of an index.
To change the properties of an object, complete the following steps:
  1. With the model open in the Data Model Editor, right-click the object whose properties you want to change, and click Show Properties. Alternatively, you can double-click the object and go to the Properties view.
  2. Use the tabs in the Properties view to change the properties that are associated with the object. The following table shows the properties that you can change:
    Table 1. Object properties that can be changed
    Object Tab option Description

    Schema
    Buffer pool
    Partition group
    Alias

    General You can edit the name, label, and various other attributes of the object.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Table space General You can edit the name, label, and various other attributes of the object.
    Tables You can specify the tables.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Table General You can edit the name, label, and various other attributes of the object.
    Columns You can add or delete columns, reorder the columns by using the up and down arrows, rename columns, select the primary key, select the domain, select the data type, edit the length, specify scale, select not null, select generated, and specify default value/generate expression.
    Partition Key You can specify how the key is to be maintained and edit the columns for the key, including the order of the columns.
    Table spaces You can select the table space to which the table belongs.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Columns (in a table) General You can edit the name and label.
    Type You can select the data type and properties of the column (primary key, null or not, and identity).
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Index General You can edit the name, label, and schema.
    Details You can specify whether the index is unique or clustered, add or delete key or include columns, and change the order of the index columns.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Primary key General You can edit the name, label, and various other attributes of the object.
    Columns You can add or delete columns in the key and reorder the columns by using the up and down arrows.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Foreign key General You can edit the name, label, and various other attributes of the object.
    Details You can add, delete, or reorder columns in the foreign key.
    Referential integrity You can change update and delete preferences.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Materialized query table General You can edit the name, label, and the attributes for how the table is to be refreshed and maintained.
    Columns You can view the columns and their data types.
    SQL You can edit, and validate the SQL expression that is used to define the materialized query table.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    View General You can edit the name, label, and various other attributes of the object.
    Columns You can view the columns and their data types.
    SQL You can edit and validate the SQL expression that is used to define the view.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Sequence General You can edit the name, label, and data type.
    Type You can specify the start, increment, minimum and maximum values of the sequence, and whether the sequence is to cycle.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    Stored Procedure General You can edit the name, label, result set, language, parameter style, and external name.
    Parameters You can change the parameters for the stored procedure.
    Source For an SQL procedure, you can change the procedure on which the stored procedure is sourced.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    User-defined function General You can edit the name, label, language, parameter style, and external name.
    Return Type You can edit the data type of the returned value.
    Parameters You can change the parameters for the function
    Source For an SQL procedure, you can change the procedure on which the stored procedure is sourced.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
    User-defined type General You can edit the name and label. For user-defined data types, you can also specify the data type, including precision and scale where applicable.
    Custom data types You can add, delete, and order custom data types. The tab is not applicable for user-defined data types.
    Documentation You can provide documentation.
    Annotation You can add or delete properties and edit their values.
  3. Click File > Save or press Ctrl + S to save your changes.
Related information
Adding keys, columns, indexes, and triggers to tables
Adding columns or triggers to views


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.