Database Object Editor

Table of contents

• Overview
• Tabs
• Content area

Overview

The Database object editor, or Metadata editor, is a general-purpose tool that provides a comprehensive interface for working with various database objects such as tables, views, and schemas. It includes several key components that help you interact with database objects:

• Tabs: Provide access to specific editors, such as Properties, Data, and Diagrams.
• Content area: Shows detailed information about the selected object.
• Toolbar: Offers tools specific to each tab to streamline tasks.

To open the Metadata editor for an object, in the Database Navigator:

• Double-click the database object.
• Click the database object and choose Open.

Tabs

Tab	Description
Properties	Available for all objects, shows the properties of the database object and its sub-entities.
Data	Appears for tables and views, represents the Data Editor.
ER Diagram	Appears for tables and schemas, displays ERD (Entity-Relationship Diagrams).

Content area

The Content Area is key part of the Metadata editor. The Content Area shows information about a database object and things like its sub-parts or DDL.