DBeaver Documentation

DOWNLOAD pdf

Simple and Advanced View

Table of contents

Overview

The Database Navigator in DBeaver displays various database objects by default, including system objects, schemas, tables, indexes, utilities, and more.

To customize or simplify the Database Navigator's contents, you may choose from three view modes:

  • Simple: This mode offers a streamlined view, ideal for users who primarily interact with tables.
  • Advanced: This mode provides a comprehensive view of all database objects that DBeaver can manage.
  • Custom: This mode allows for a personalized configuration of the Database Navigator display.

Accessing Connection view modes

To access these settings:

  1. Right-click on the desired database within the Database Navigator.
  2. Select Connection view.
  3. Choose between Simple, Advanced, or Custom to suit your preferences.

For the Custom view:

  1. After selecting Custom, an additional window will appear.
  2. In this window, you can configure the custom settings for the Database Navigator view.

Important: Changing the view modes settings affects the currently selected database. To customize the display of objects in each database individually, you must select a specific view mode for each one.

View modes features

Each view mode offers a unique set of features:

  • Simple View: Tailored for ease of use, the Simple view offers a minimalist approach, displaying only schemas and tables. It is optimal for users who focus predominantly on these database objects.

  • Advanced View: The Advanced view presents a comprehensive display of the database, showing all database objects, including system objects, all folders, and all supported objects. This mode is intended for users who require visibility across the entire database structure.

  • Custom View: For those who prefer a personalized setup, the Custom view mode provides the ability to configure the Database Navigator.

Following is a detailed comparison of the features across the different view modes, along with descriptions for the configurable options available in the Custom View:

Feature Simple View Advanced View Custom View (Configurable) Description
Show system objects No Yes Yes/No Includes or excludes system objects such as pg_catalog or SYSTEM.
Show utility objects No Yes Yes/No Includes or excludes utility objects like template databases for new database creation.
Show only schemas and tables Yes No Yes/No Displays only schemas and tables, hiding all other objects for a simplified view.
Show all tables in a single list No No Yes/No Consolidates all tables into one list, regardless of their schema.
Hide folders Yes No Yes/No Hides all intermediate logical folders, displaying objects directly.

Additional settings

In addition to selecting a view mode, there are other settings accessible via the Connection view context menu. These settings provide additional information about the database objects and enhance your experience:

Setting Description
Show connection host name Displays the host name or tunnel of the current database next to the connection name.
Show objects description Shows object (table, column, etc.) description next to it.
Show statistics info Provides statistical information on objects (e.g. table size), on the right side of the Database Navigator.
Show action icons Shows action icons for database elements.
For example, you can see a read-only icon on the right side of the Database Navigator, indicating that a particular connection is in a read-only state.

These settings can be toggled on or off based on your preference, allowing for a customized Database Navigator. To access and modify these settings:

  1. Right-click on the desired database within the Database Navigator.
  2. Navigate to the relevant options.
  3. Select or deselect the options to show or hide the desired information.

Note: These settings alter the display for the entire Database Navigator, affecting how all database objects are presented.