Online Documentation for SQL Manager for Oracle

Specifying fields


The Fields tab is intended for setting up table fields. Double-click a field to open Field Editor for editing the field.

 

Right-click within the Table Fields area to display the context menu allowing you to add, insert, edit, delete, and reorder fields.

 

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

 

New table - Specifying fields

 

The Fields list provides the following attributes of each field of the table:

Key

Column Name

Data Type

Size

Scale

Not Null

Default Value

 

Click within the Key column to specify a primary key field, and type the name of the primary key constraint name in the corresponding edit box.

 

For details see Fields.

 

To compile the table, use the iconCompile Compile item available within the Navigation bar.