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.
- Database object path: Displays the hierarchy of parent entities.
- 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 or in the Projects view:
- Double-click the database object
- Click the database object and press Enter or F4
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). |
Database object path
The object's path shows the chain of all its parent entities. The entities are clickable: clicking an entity in the path, depending on its nature, either shows its children or opens an editor or a settings window.
Content area and Toolbar
The Content Area and Toolbar are key parts of the Properties tab. The Content Area shows information about a database object and things like its sub-parts or DDL. The Toolbar has different tools on each tab to help with different tasks.