Editing Online Tables

Edit online database tables and offline and modeled tables from the Edit Table dialog, or the Edit Offline Table dialog.

To edit an online table:

1. Select View Connection Navigator.
2. Expand Database and select a database connection.
3. In the connection, expand a schema.
4. In the schema, expand Tables.
5. Right-click a table name and select Edit, or double-click the table name.
6. The Edit Table dialog opens.

To edit an offline table:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline table and choose P roperties.
   Or
   Double-click the offline table.
3. The Edit Offline Table dialog opens.

To edit an offline table:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline table and choose P roperties.
   Or
   Double-click the offline table.
3. The Edit Offline Table dialog opens.

In the Edit Table dialog or the Edit Offline Table dialog, select an information category on the left and change the values in that category on the right. Any items that are grayed out cannot be selected or changed.

Related topics

Creating, Editing, and Dropping Schema Objects

Copyright © 1997, 2004, Oracle. All rights reserved.