Primary Keys Editor (IBM DB2 LUW)

From RapidSQL
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Primary Keys Editor lets you manage columns and properties for a primary key, and view space usage/allocation details.

To edit a primary key

  1. Open an editor on the primary key. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Columns

Displays the columns that make up the primary key. Optionally, you can:

Select a column and use the Delete key to remove the column from the primary key.

Select a column and use the arrow keys to reorder the columns in the primary key.

Properties

Displays the owning Table Schema and Table Name, the Name of the primary key, a Defined By property, and Percent Free and Minimum Percent Used properties.

Space

Lets you view the following property groups:

Attributes

Make Unique, System Required, Total Keys, Page Fetch Pairs, and Distinct Keys

Statistics

Index Level, Cluster Ratio, Cluster Factor, Leaf Pages, Sequential Pages, and Density

Cards

First Key, First 2 Keys, First3 Keys, First 4 Keys, and Full Keys

Comment

For details on using this tab, see Adding a Comment to an object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.