Oracle 5.0, Reference Manual

Page: 1851 / 3232

Connector/Net Visual Studio Integration
1831
To set or change the name, data type, default value and comment of a column, activate the appropriate
cell and type the desired value.
To set or unset flag-type column properties (
NOT NULL
, auto incremented, flags), check or uncheck the
corresponding check boxes. Note that the set of column flags depends on its data type.
To reorder columns, index columns or foreign key columns in the Column Editor, select the whole
column to reorder by clicking the selector column on the left of the column grid. Then move the column
by using Up (to move the column up) or Down (to move the column down) keys.
To delete a column, select it by clicking the selector column on the left of the column grid, then press
the Delete button on a keyboard.
20.2.3.3.2. Editing Indexes
Indexes management is performed using the Indexes/Keys dialog.
To add an index, select Table Designer, Indexes/Keys... from the main menu, and click Add to add a
new index. You can then set the index name, index kind, index type, and a set of index columns.
Figure 20.9. Indexes Dialog
To remove an index, select it in the list box on the left, and click the Delete button.
To change index settings, select the needed index in the list box on the left. The detailed information
about the index is displayed in the panel on the right hand side. Change the desired values.
20.2.3.3.3. Editing Foreign Keys
You manage foreign keys for
InnoDB
tables using the Foreign Key Relationships dialog.
To add a foreign key, select Table Designer, Relationships... from the main menu. This displays the
Foreign Key Relationship dialog. Click Add. You can then set the foreign key name, referenced table
name, foreign key columns, and actions upon update and delete.