Database Object Editor

Table of contents

• Tabs
• Database object path
• Content area and Toolbar

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.
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.