Online Documentation for SQL Manager for DB2

Primary and unique keys


The Primary/Unique Key tab is provided for managing table keys. Double-click a key to open Primary/Unique Key Editor for editing the key.

 

Right-click a key to display the context menu allowing you to create new, view, or drop the selected primary/unique key. Using the menu you can also export the list of the table keys to any of supported formats.

 

Keys management tools are also available through the Navigation bar of Table Editor.

 

Table Editor - Constraints - Primary and Unique keys

 

 

The Keys list provides the following attributes of each key of the table:

Field Name

Primary

Constraint Name

 

For details see Primary/Unique keys.