Table properties (DB2 UDB for Linux, UNIX, and Windows or iSeries)

Use the Properties view to modify the properties of a DB2® UDB for Linux®, UNIX®, and Windows® or iSeries™ table.

For more information about DB2 UDB for Linux, UNIX, and Windows or iSeries syntax, see the reference information that is included with the product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Columns page
Use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for columns.
  • Click the New toolbar button to add a new column to the bottom of the grid.
  • Click the Delete toolbar button to delete a column.
  • Select a column in the grid and click Move Column Up or Move Column Down to change the order of columns.
  • Use the grid to modify the properties of a column. Double-click a cell or click a check box in a cell to edit the cell contents. Note: You can also select a single column in either the Data Project Explorer or a diagram and modify these and other properties in the Properties view for the column. When you modify properties from the Properties view for a column, additional properties are available to modify.
    Property Description
    Primary Key Select to designate a column as a primary key column.
    Domain Select a domain data type for the column. You must associate a domain model with the data design project or define domains in your physical model to see domain data types in this list.
    Data type Select a base data type for the column.
    Length Specify a length for the column. Only available if you select a domain or base data type that requires a length specification.
    Scale Specify a scale for the column. Only available if you select a domain or base data type that requires a scale specification.
    Not Null Select to prevent the column from containing null values.
    Generated Select to designate that values for this column are generated by DB2.
    Default Value - Generate Expression Specify a default value or expression for the column. If you select the Generated check box for this column, this field designates an expression. If the you do not select the Generated check box for this column, this field designates a default value. You can type a value or expression or select a value or expression from the list.
Partition key page (for DB2 UDB for Linux, UNIX, and Windows only)
Use the grid and the toolbar buttons on this page to add, delete, change the order, and modify properties for partition key columns.
Prerequisites for setting partition key properties:
  • The table must be partitioned to a table space.
  • The table space must be partitioned.
  • To add a new column to the partition key, click the ellipsis [...] toolbar button, select columns in the window that opens, and click OK.
  • To change the order of columns, select a column in the grid and click Move Column Up or Move Column Down.
  • Use the grid to modify the properties of a partition key column. Double-click a cell or click a check box in a cell to edit the cell contents.
    Property Description
    Maintained By Select an option for the PARTITIONING KEY clause. You can select HASHING (USING HASHING) or TABLE_REPLICATED (REPLICATED).
    Column Shows the name of the column. This property cannot be edited.
    Data type Shows the data type of the column. This property cannot be edited.
Table spaces page
Property Description
Regular Select a table space for the table. Click Show Properties Show Properties icon to open the Properties view for the selected object.
Index Select a table space in which any indexes on the table will be created. Click Show Properties Show Properties icon to open the Properties view for the selected object.
LOB Select a table space in which the values of any long columns will be stored. Click Show Properties Show Properties icon to open the Properties view for the selected object.
Relationships page
Shows objects that are related to the object and information about the relationship. These fields cannot be edited. Select a relationship in the grid and click Show Properties Show Properties icon to open the Properties view for a related object. Use a data diagram to add relationships between objects.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback