Primary Keys Editor (IBM DB2 LUW)
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
- Open an editor on the primary key. For details, see Opening an Object Editor.
- 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.