Database Navigator is the main view to work with the structure and content of databases. To open Database Navigator, on the Windows menu, click Database Navigator. For information on how to change the view layout, please see the Application Window Overview article.

    Database Navigator - 图1

    Database Navigator contains a tree of objects, a toolbar and View menu which contain generic items. Each object in the tree has its own context menu.The tree contains the following objects:

    • Folders - Database Navigator - 图2
    • Database connections - Database Navigator - 图3Database Navigator - 图4Database Navigator - 图5Database Navigator - 图6Database Navigator - 图7 and other (icons differ depending on the database type)
    • Database objects - various depending on the database type, such as Tables Database Navigator - 图8, Views Database Navigator - 图9, Columns Database Navigator - 图10Database Navigator - 图11, Indexes Database Navigator - 图12, etc.
      To open the view menu of Database Navigator, click the View Menu button (Database Navigator - 图13) in the upper-right corner of the window.For more information on where to find the view toolbar and menu, please see the Views article.

    The menu contains the following items:

    IconMenu itemDescription
    Database Navigator - 图14Driver ManagerOpens the Driver Manager window that allows creating, editing and deleting drivers for databases. See Database Drivers for information about managing database drivers.
    Database Navigator - 图15New ConnectionOpens the Create new connection wizard. See Create Connection for information about creating connections.
    (empty)Active ProjectDisplays a submenu which allows you to choose a project. See Projects and Projects view for information about projects.
    Database Navigator - 图16New FolderOpens a dialog box for creating a new folder
    Database Navigator - 图17Collapse AllCollapses the tree to the root level
    Database Navigator - 图18Link with editorEnabled when at least one editor is open, otherwise disabled - highlights the object in the tree that has its editor open

    The toolbar is located in the title bar of the window. Its buttons duplicate the menu items, except for the Active Project.

    To open the context menu for an object, right-click the object in the tree. The following table summarizes context menu items for all types of objects that may appear in the tree. Note that the presence or absence of context menu items for an object depends on the database and object types.

    Menu itemDescription
    Open folderOpens a folder in a separate view
    Create new connections / Create New ConnectionOpens the Create new connection wizard
    New FolderOpens a dialog box for creating a new folder
    CopyCopies an object to the clipboard
    PasteInserts the copied object into a selected folder - most convenient for copy-pasting connections
    DeleteDeletes an objectWARNING! The Delete menu item removes the object not only from the tree but from the database itself or the file system, and this action is irreversible.
    RenameOpens the Rename [object] dialog box
    PropertiesOpens the Properties for [object] window which allows viewing and modifying the objects properties</td></tr><tr><td>**Refresh**</td><td>Depending on the object, refreshes the object itself, or its parent, or its subnodes – mostly used for refreshing tables and schemes</td></tr><tr><td>**Connect**</td><td>Attempts to connect to the database</td></tr><tr><td>**Invalidate/Reconnect**</td><td>Checks the status of connection, if it is broken, attempts to reconnect</td></tr><tr><td>**Disconnect**</td><td>Disconnects from the database</td></tr><tr><td>**SQL Editor**</td><td>Opens a new SQL editor for the connection</td></tr><tr><td>**Recent SQL Editor**</td><td>Opens the most recently opened SQL editor</td></tr><tr><td>**Edit Connection**</td><td>Opens the Connection Configuration window that allows configuring connection settings</td></tr><tr><td>**View [objects]**</td><td>-For objects that DBeaver can create and delete, opens the object in a separate editor-For objects that DBeaver cannot create and delete, opens the object in a separate viewer</td></tr><tr><td>**Edit [object]**</td><td>-For objects that DBeaver can create and delete, opens the object in a separate editor-For objects that DBeaver cannot create and delete, opens the object in a separate viewer</td></tr><tr><td>**Create new [object]**</td><td>Opens an editor in which you can specify properties and save the new object</td></tr><tr><td>**Filter**</td><td>Opens a submenu of one or more filtering options (depending on the object):-Hide [object]-Show only [object]-Configure [objects] filter-Toggle filter-Clear filter See [Filters]($a01e6d7854a461ac.md) for information.</td></tr><tr><td>**Copy Advanced Info**</td><td>Copies the full name of an object</td></tr><tr><td>**Read Data in SQL Console**</td><td>Opens an SQL console displaying the objects data
    Copy Advanced InfoCopies the full name of an object
    Read Data in SQL ConsoleOpens an SQL console displaying the object`s data
    Compare- Appears only if you select several objects of the same level - Opens the Compare objects wizard which guides you through the steps to generate a comparison report for the selected objects
    Generate SQLOpens a submenu on which you can select the type of SQL query to generate:- SELECT- INSERT- UPDATE- DELETE- MERGE- DDL Clicking one of the items (for example INSERT) generates a relevant query in a separate window.
    Export Table DataOpens the Data Transfer wizard that helps you select a format and export table data
    Import Table DataOpens a window with existing database connections in which you can select a table to import data from
    ToolsOpens a submenu that provides tools for database backup and restore, vacuum, etc.

    For information on how to filter database objects in Database Navigator, please see the Filter Database Objects article.