Database Object Editor
Table of contents
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.