-
Notifications
You must be signed in to change notification settings - Fork 3.6k
Database Object Editor
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
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). |
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.
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.
-
Views
-
Search
-
Data management
-
Usability enhancements
-
Security
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
-
Tableau integration
- Transactions
- Drivers
- Tasks
-
Cloud Explorer
-
Cloud Storage
- Classic
- Cloud
- Embedded
- File drivers
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation