Online Documentation for SQL Manager for Oracle

Creating/editing key


Use the Primary/Unique Key tab of Key Editor to create/edit a primary or unique key constraint and specify its properties.

 

Name

Specify the name of the key to be created, or view the name of the key being edited. Note that the key name must be unique within its schema.

 

CheckBox System named

If this option is selected, Oracle will generate the key name automatically when compiling the key definition.

 

Schema

Use the drop-down list to specify the schema in which the key will be created.

 

Key Editor - Editing key definition

 

Table or View

Use the drop-down list to select the table or view for which the key is created.

 

The Key fields area allows you to specify one or more table/view columns for the key.

To select a column, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.

 

CheckBox Create as unique key

Designates the key as a unique key.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar.