Editing Tables

To edit a 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, right-click Tables.
  5. From the context menu, right-click a table name and select Edit.
  6. From the Edit 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.
  7. Click OK to save changes and exit the dialog.

For information about how to fill in values for the the wizard parameters and options, click Help in the dialog, or see the CREATE TABLE section of the Oracle Database SQL Reference, available from the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.


Creating, Editing, and Dropping Schema Objects

 

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