Unique Keys Editor (IBM DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors
The Unique Keys Editor lets you manage columns and basic properties for a unique key, as well as view space details.
To edit a unique key
- Open an editor on the unique 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 |
[JavaScript:popup.TextPopup(Poptext1,Popfont,9,9,-1,-1) Lets you manage columns that make up the unique key. On opening, this tab shows the existing columns. For each column, the datatype (and if applicable the precision in brackets) and whether the table definition permits nulls in the target table column.] Optionally you can: | |
Click the New button and select a column name from the dropdown, to add a column to the index. | ||
Select a column and click the Drop button to delete the column from the index. | ||
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 settings in the following categories: | |
Attributes |
Lets you view Make Unique, System Required, Total Keys, Distinct Keys, and Page Fetch Pairs settings. | |
Statistics |
Lets you view Index Level, Cluster Ration, Cluster Factor, Leaf Pages, Sequential Pages, and Density settings. | |
Cards |
Lets you view First Key, First 2 Keys, First 3 Keys, First 4 Keys and Full Keys settings. | |
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.