Editing database objects

You can edit database objects such as tables, columns, primary keys, and foreign keys.

The Data perspective provides a table editor for editing existing database objects, such as tables, columns, primary keys, and foreign keys. To open the table editor, you can either double-click on the table in the Data Definition view of the Data perspective or right-click on the table in the Data Definition view and click Open. Whenever the table editor opens, the Outline view also opens. The relational data objects are listed in the Outline view in a tree structure. Use the Outline view as a visual aid and for navigational purpose to open the appropriate page in the table editor.

You can change database and schema definitions after they are defined with the Table Definition wizard. For example, you can change the name of the table or the schema that it relates to. By using the table editor, you can also add columns to a table and change their types. You can change the primary key, the foreign keys, and views. You can also create and delete databases, schemas, and tables.

If you edit related data objects at the same time, you risk damaging your data model. Generally, you should edit only one data object at a time. When you are finished editing one data object, close its editor before you open the editor for another data object.

The editor has limited parsing support for some Oracle scripts. When you edit Oracle scripts or run them on a local database, you might receive parsing errors or they will display in the tree view with an icon that indicates an error. For example, CREATE SEQUENCE, CREATE OR REPLACE TRIGGER, and END statements are not supported. However, you can ignore these errors and proceed to export these items to an Oracle server.

 

Parent topic

Modifying database objects

 

Related tasks

Renaming data objects
Copying or moving data objects
Deleting database objects
Dropping tables