# Database tool window > **TL;DR** > `View | Tool Windows | Database` Procedure: Enable the Database Tools and SQL plugin This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. If the relevant features are not available, make sure that you did not disable the plugin. > **Note:** > Database Tools and SQL functionality support is limited in IntelliJ IDEA without the Ultimate subscription. 1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`. 2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. ## Overview In the Database tool window , you can work with databases and DDL [data sources](managing-data-sources.html#data_sources) . You can view and modify data structures in your databases and perform other associated tasks. The available data sources are shown as a tree of data sources, schemas, tables, and so on. ![Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/db_database_tool_window.png) If no data sources are currently defined, Database tool window displays the quick actions that help you start creating a data source or use the demo data sources. You can also use the [New](#new) command `Alt+Insert` (Windows), `⌘ N` (macOS), `⌃ N` (IntelliJ IDEA Classic (macOS)), `⌘ N` (macOS System Shortcuts), `Alt+Insert` (XWin), `Alt+Insert` (GNOME), `Alt+Insert` (KDE), `Alt+Insert` (Emacs), `Ctrl+N` (Sublime Text), `⌘ N` (Sublime Text (macOS)), `Alt+Insert` (NetBeans), `Ctrl+N` (Visual Studio), `⌘ N` (Visual Studio (macOS)), `Alt+Insert` (Eclipse), `⌘ N` (Eclipse (macOS)) to create a data source and connect to a database. For more information about data sources, refer to [Data sources](managing-data-sources.html) topic. Once IntelliJ IDEA is connected to a database, Database tool window will display the [introspected](glossary-database-tools-and-sql.html#introspection) database objects. For more information about database tree viewing options, refer to [View Options](#view_options) chapter. For more information about working with database objects in IntelliJ IDEA, refer to the corresponding object topics. Most of the functions in this window are accessed by using the toolbar icons or context menu commands. Many of the commands have keyboard shortcuts. > **Tip:** > If the toolbar is not currently shown, click ![the Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.moreVertical.svg) Options on the header and select Show Toolbar. ## Browse your databases Procedure: Find database objects * To search for a database object in Database tool window , start typing the object's name. Matching database objects will be highlighted. To toggle the speed search filter, click ![the Speed Search Filter icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.funnelRegular.svg) Speed Search Filter. To move between several highlighted items, press `Up` (Windows), `↑` (macOS), `↑` (IntelliJ IDEA Classic (macOS)), `↑` (macOS System Shortcuts), `Up` (XWin), `Up` (GNOME), `Up` (KDE), `Up` (Emacs), `Up` (Sublime Text), `↑` (Sublime Text (macOS)), `Up` (NetBeans), `Up` (Visual Studio), `↑` (Visual Studio (macOS)), `Up` (Eclipse), `↑` (Eclipse (macOS)) and `Down` (Windows), `↓` (macOS), `↓` (IntelliJ IDEA Classic (macOS)), `↓` (macOS System Shortcuts), `Down` (XWin), `Down` (GNOME), `Down` (KDE), `Down` (Emacs), `Down` (Sublime Text), `↓` (Sublime Text (macOS)), `Down` (NetBeans), `Down` (Visual Studio), `↓` (Visual Studio (macOS)), `Down` (Eclipse), `↓` (Eclipse (macOS)). For more information about speed search, refer to [Speed Search in tool windows](speed-search-in-the-tool-windows.html). [Video](https://resources.jetbrains.com/help/img/idea/2026.2/tool_window_speed_search_toggle.mp4) Procedure: Filter database objects You can filter database objects and hide the objects you do not need to see. To do this, use either the object filter in data source settings or the tool window item filter. * Object filter in data source settings For example, you can filter out all tables with names starting with `payment_`. 1. To filter database objects, open Data Sources and Drivers dialog ( `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) ) . 2. On the left pane of the dialog, select the data source in which you want to filter database objects. 3. In the Schemas tab, navigate to Object filter and enter the pattern. In our example, `table:-payment_.*`. > **Tip:** > In the Object filter field, press `Ctrl+Q` (Windows), `F1` (macOS), `⌃ J` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Ctrl+Q` (XWin), `Ctrl+Q` (GNOME), `Ctrl+Q` (KDE), `Ctrl+Q` (Emacs), `Ctrl+Q` (Sublime Text), `Ctrl+Q` (Sublime Text (macOS)), `Ctrl+Q` (NetBeans), `Ctrl+K, I` (Visual Studio), `⌘ K, I` (Visual Studio (macOS)), `Alt+Middle-Click` (Eclipse), `⌥ Middle-Click` (Eclipse (macOS)) for the information about syntax. ![Filtering out tables in the data source settings dialog](https://resources.jetbrains.com/help/img/idea/2026.2/db_database_explorer_data_source_settings_object_filter.png) * Item filter in the tool window view options 1. In the toolbar, click ![the View Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options and select ![the Filter icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.filter.svg) Filter. 2. Select or deselect the items that you want to see or hide. 3. To confirm the selection, click any area in the Database tool window . ![Only views and tables are selected to view in Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/database_tool_window_items_filter_on.png) Procedure: Show more schemas Database tool window displays introspected databases and schemas of your data sources. For a database or schema to be shown in the tree, select it in the schema selector of a data source. For more information about introspection, refer to [Glossary](glossary-database-tools-and-sql.html#introspection). * To see more schemas under your new data source node, click the N of M button and select the ones you need. IntelliJ IDEA will introspect and show them. ![Select databases and schemas to introspect and display in the Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/connection_flow_show_databases_and_schemas.png) Procedure: View a group in a table * In the Database tool window , click a node that groups database objects, and press `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)). For more information about toggling groups view, refer to [Customize the view of objects](#customize_the_view_of_objects). ![View the contents of a node](https://resources.jetbrains.com/help/img/idea/2026.2/view_contents_of_a_node.png) Procedure: View quick documentation * [Quick documentation](viewing-reference-information.html#inline-quick-documentation) displays information about the item. To view the information, select the item and press `Ctrl+Q` (Windows), `F1` (macOS), `⌃ J` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Ctrl+Q` (XWin), `Ctrl+Q` (GNOME), `Ctrl+Q` (KDE), `Ctrl+Q` (Emacs), `Ctrl+Q` (Sublime Text), `Ctrl+Q` (Sublime Text (macOS)), `Ctrl+Q` (NetBeans), `Ctrl+K, I` (Visual Studio), `⌘ K, I` (Visual Studio (macOS)), `Alt+Middle-Click` (Eclipse), `⌥ Middle-Click` (Eclipse (macOS)). ![Table information in Quick Documentation popup in the Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/quick_doc_table_preview.png) Procedure: Scroll to the object opened in editor * To scroll to a database object in the database tree, place the caret over the object's name in code editor. Then, in Database tool window tool window toolbar, click ![Scroll from Editor](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.locate.svg) Scroll from Editor. The corresponding nodes will open and the object will be highlighted in the database tree. [Video](https://resources.jetbrains.com/help/img/idea/2026.2/db-forest-config.xml`. You can add this configuration file to the VCS to share it with your colleagues, or you can also ignore it in the VCS. Procedure: Move tree items to folders * To group data sources in a folder or move one folder to another, right-click the item and select `Move | To Folder`. In the Move to Folder popup, select the folder you want to move the item to. You can move the item to an existing folder, create a new folder and move the item in it, or move the item to the top level. > **Tip:** > If you already have folders, drag a data source to add it to a folder. For more information about grouping data sources, refer to [Group data sources in folders](managing-data-sources.html#group-data-sources-in-folders). ![Move an item to a folder](https://resources.jetbrains.com/help/img/idea/2026.2/database_tree_move_to_folder.png) Procedure: Reorder folders and data sources To move folders and data sources in the tree, use the Move context menu actions and corresponding shortcuts. * To move an item up and down the list, select `Move | Up` and `Move | Down`. Alternatively, press `Alt+Shift+Up` (Windows), `⌥ ⇧ ↑` (macOS), `⌥ ⇧ ↑` (IntelliJ IDEA Classic (macOS)), `⌥ ⇧ ↑` (macOS System Shortcuts), `Alt+Shift+Up` (XWin), `Alt+Shift+Up` (GNOME), `Alt+Shift+Up` (KDE), `Alt+Shift+Up` (Emacs), `Ctrl+Shift+Up` (Sublime Text), `⌘ ⌃ ↑` (Sublime Text (macOS)), `Alt+Shift+Up` (NetBeans), `Alt+Shift+Up` (Visual Studio), `Alt+Shift+Up` (Visual Studio (macOS)), `Alt+Shift+Up` (Eclipse), `Alt+Shift+Up` (Eclipse (macOS)) and `Alt+Shift+Down` (Windows), `⌥ ⇧ ↓` (macOS), `⌥ ⇧ ↓` (IntelliJ IDEA Classic (macOS)), `⌥ ⇧ ↓` (macOS System Shortcuts), `Alt+Shift+Down` (XWin), `Alt+Shift+Down` (GNOME), `Alt+Shift+Down` (KDE), `Alt+Shift+Down` (Emacs), `Ctrl+Shift+Down` (Sublime Text), `⌘ ⌃ ↓` (Sublime Text (macOS)), `Alt+Shift+Down` (NetBeans), `Alt+Shift+Down` (Visual Studio), `Alt+Shift+Down` (Visual Studio (macOS)), `Alt+Shift+Down` (Eclipse), `Alt+Shift+Down` (Eclipse (macOS)). * To move an item to the highest level of the tree, select `Move | To Top Level`. ![Reorder folders in Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/database_tree_folders_reorder.png) ## Configure the tree view Procedure: Customize the view of objects * To group, enable, or sort data sources, click ![the View Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options on the Database tool window toolbar and select the necessary options. In the Database tool window , the view of database objects tree changes instantly. For more information about the database tree view options, refer to [View Options](#view_options). ![View Options menu items in Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/database_tool_window_options_menu_items.png) Procedure: Toggle groups for non-major objects * By default, non-major objects are grouped in the Database Objects and Server Objects nodes. To toggle this grouping, click ![the View Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options in the toolbar, navigate to View in Groups and click Database and Server Objects. For more information about view options, refer to the [Database](#view_options) topic. * Grouping enabled ![Grouping of non-major objects is enabled](https://resources.jetbrains.com/help/img/idea/2026.2/db_database_explorer_view_options_group_non_major_objects_enabled.png) * Grouping disabled ![Grouping of non-major objects is disabled](https://resources.jetbrains.com/help/img/idea/2026.2/db_database_explorer_view_options_group_non_major_objects_disabled.png) Procedure: Show tree indent guides In the Database tool window , you can display vertical lines that mark indent levels and help you better understand the hierarchy of the objects in your databases . 1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Appearance & Behavior | Appearance`. 2. In the Tree Views section, enable the Show indent guides option. * Tree indent guides are enabled ![The Show tree indent guides setting is enabled](https://resources.jetbrains.com/help/img/idea/2026.2/db_show_tree_indent_guides_database_tree_on.png) * Tree indent guides are disabled ![The Show tree indent guides setting is disabled](https://resources.jetbrains.com/help/img/idea/2026.2/db_show_tree_indent_guides_database_tree_off.png) Procedure: Show comments and last refresh date You can view comments and last refresh timestamps for the objects in the database tree. * In the toolbar, click ![the View Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options, navigate to Node Details and select Comments and Schema Refresh Time. Procedure: Group object by prefix * To group objects by prefix, click ![the View Options icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options on the Database tool window toolbar and select Schema Objects by Prefix. ## Productivity tips Procedure: Create a quick table backup * You can create a quick table backup before any significant data manipulation. To do this, drag the table to the original schema and create a copy of the table in Import dialog. For more information about the dialog, refer to [Import dialog](import-data.html#import_dialogs). [Video](https://resources.jetbrains.com/help/img/idea/2026.2/quick_table_backup.mp4) ## Reference info ### Header toolbar You can right-click the window header and use the context menu to configure its [viewing mode](viewing-modes.html), associate the window with a different [tool window bar](tool-windows.html#bars_and_buttons), or resize and hide the window. You can also use the toolbar buttons: | Item | Shortcut | Description | | --- | --- | --- | | ![Scroll from Editor](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.locate.svg) | | Automatically sets the focus on the object name in the Database tool window when the editor area is in focus. | | ![Expand All](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.expandAll.svg) | `Ctrl+NumPad +` (Windows), `⌘ NumPad +` (macOS), `⌘ NumPad +` (IntelliJ IDEA Classic (macOS)), `⌘ NumPad +` (macOS System Shortcuts), `Ctrl+NumPad +` (XWin), `Ctrl+NumPad +` (GNOME), `Ctrl+NumPad +` (KDE), `Ctrl+NumPad +` (Emacs), `Ctrl+NumPad +` (Sublime Text), `⌘ NumPad +` (Sublime Text (macOS)), `Ctrl+NumPad +` (NetBeans), `Ctrl+NumPad +` (Visual Studio), `⌘ NumPad +` (Visual Studio (macOS)), `Ctrl+Shift+NumPad *` (Eclipse), `⌘ ⇧ NumPad *` (Eclipse (macOS)) | Expand all nodes in the current view. | | ![Collapse all](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.collapseAll.svg) | `Ctrl+NumPad -` (Windows), `⌘ NumPad -` (macOS), `⌘ NumPad -` (IntelliJ IDEA Classic (macOS)), `⌘ NumPad -` (macOS System Shortcuts), `Ctrl+NumPad -` (XWin), `Ctrl+NumPad -` (GNOME), `Ctrl+NumPad -` (KDE), `Ctrl+NumPad -` (Emacs), `Ctrl+NumPad -` (Sublime Text), `⌘ NumPad -` (Sublime Text (macOS)), `Ctrl+NumPad -` (NetBeans), `Ctrl+NumPad -` (Visual Studio), `⌘ NumPad -` (Visual Studio (macOS)), `Ctrl+Shift+NumPad /` (Eclipse), `⌘ ⇧ NumPad /` (Eclipse (macOS)) | Collapse all expanded nodes in the current view. | | ![Hide tool window](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.hide.svg) | `Shift+Escape` (Windows), `⇧ ⎋` (macOS), `⇧ ⎋` (IntelliJ IDEA Classic (macOS)), `⇧ ⎋` (macOS System Shortcuts), `Shift+Escape` (XWin), `Shift+Escape` (GNOME), `Shift+Escape` (KDE), `Shift+Escape` (Emacs), `Shift+Escape` (Sublime Text), `⇧ ⎋` (Sublime Text (macOS)), `Shift+Escape` (NetBeans), `Shift+Escape` (Visual Studio), `⇧ ⎋` (Visual Studio (macOS)), `Shift+Escape` (Eclipse), `⇧ ⎋` (Eclipse (macOS)) | Hide the tool window . To hide all the tool windows, press `Ctrl+Shift+F12` (Windows), `⌘ ⇧ F12` (macOS), `⌘ ⇧ F12` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ F12` (macOS System Shortcuts), `Ctrl+Shift+F12` (XWin), `Ctrl+Shift+F12` (GNOME), `Ctrl+Shift+F12` (KDE), `Ctrl+Shift+F12` (Emacs), `Ctrl+Shift+F12` (Sublime Text), `⌘ ⇧ F12` (Sublime Text (macOS)), `Ctrl+Shift+F12` (NetBeans), `Ctrl+Shift+F12` (Visual Studio), `⌘ ⇧ F12` (Visual Studio (macOS)), `Ctrl+Shift+F12` (Eclipse), `⌘ ⇧ F12` (Eclipse (macOS)). | ### Header context menu | Item | Description | | --- | --- | | Autoscroll from Editor | Makes the database object, that is opened in the editor, automatically selected in the Database tool window . Disables the ![Scroll from Editor](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.locate.svg) Scroll from Editor setting. | | Show Query Console Toolbar | Display the toolbar in the [query console tabs](query-consoles.html#reference). | | ![the Speed Search icon](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.search.svg) Speed search | Opens the input field of the [Speed Search in tool windows](speed-search-in-the-tool-windows.html) feature. | | Show Toolbar | Display the toolbar in the Database tool window . | | View Mode | This option lets you control general appearance and behavior of the tool window. For full information, refer to [Tool window view modes](viewing-modes.html). | | Move to | To associate the tool window with a different [tool window bar](tool-windows.html#bars_and_buttons), select this command, and then select the destination tool window bar (Top, Left, Bottom or Right). For full information, refer to the [Move tool windows](manipulating-the-tool-windows.html#move-tool-windows) chapter. | | Resize | To resize the tool window by moving one of its borders, select this command, and then select the necessary Stretch to option. Note that this command is not available for the floating mode. | | Remove from Sidebar | This command hides the tool window, removes the associated [tool window button](tool-windows.html#bars_and_buttons) from the tool window bar, and removes the tool window from the [quick access menu](tool-windows.html) ( ![tb shown](https://resources.jetbrains.com/help/img/idea/2026.2/app.general.tbShown.svg) or ![tb hidden](https://resources.jetbrains.com/help/img/idea/2026.2/app.general.tbHidden.svg)). To open the tool window again (and restore the associated features), use the main menu: `View \| Tool Windows \| ` or press `Alt+1` (Windows), `⌘ 1` (macOS), `⌘ 1` (IntelliJ IDEA Classic (macOS)), `⌘ 1` (macOS System Shortcuts), `Alt+1` (XWin), `Alt+1` (GNOME), `Alt+1` (KDE), `Alt+1` (Emacs), `Alt+1` (Sublime Text), `⌘ 1` (Sublime Text (macOS)), `Ctrl+1` (NetBeans), `Ctrl+Alt+L` (Visual Studio), `⌘ ⌥ L` (Visual Studio (macOS)), `Alt+1` (Eclipse), `Alt+1` (Eclipse (macOS)). | | Help | This command opens the description of the Project tool window in the IntelliJ IDEA online help. | ### Toolbar ![Database tool window toolbar](https://resources.jetbrains.com/help/img/idea/2026.2/database_tool_window_toolbar.png) ![the New icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.add.svg) : New : : Create a new data source, query console, or a driver. : : : : Available for: Data sources and database objects. : : : : Database objects creation is available only with the Ultimate subscription. ![the Data Source Properties icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.manageDataSources.svg) : Data Source Properties `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) : : Open the [Data Sources and Drivers : dialog](data-sources-and-drivers-dialog.html) to manage your data sources and their settings. : : : : Available for: All node types. ![the Refresh icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.refresh.svg) : Refresh `Ctrl+F5` (Windows), `⌘ R` (macOS), `⌃ F5` (IntelliJ IDEA Classic (macOS)), `⌘ R` (macOS System Shortcuts), `Ctrl+F5` (XWin), `Ctrl+F5` (GNOME), `Ctrl+5` (KDE), `Ctrl+F5` (Emacs), `Ctrl+F5` (Sublime Text), `⌘ R` (Sublime Text (macOS)), `Ctrl+F5` (NetBeans), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)) : : Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). : : : : See also, [Data Sources and Drivers dialog](data-sources-and-drivers-dialog.html#auto_sync). : : : : Available for: Data sources and their elements. ![the Deactivate icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.killDataSourceProcess.svg) : Deactivate `Ctrl+F2` (Windows), `⌘ F2` (macOS), `⌘ F2` (IntelliJ IDEA Classic (macOS)), `⌃ ⇧ .` (macOS System Shortcuts), `Ctrl+F2` (XWin), `Ctrl+F2` (GNOME), `Ctrl+2` (KDE), `Ctrl+F2` (Emacs), `Ctrl+F2` (Sublime Text), `Ctrl+F2` (Sublime Text (macOS)), `Shift+F5` (NetBeans), `Shift+F5` (Visual Studio), `⇧ F5` (Visual Studio (macOS)), `Ctrl+F2` (Eclipse), `⌘ F2` (Eclipse (macOS)) : : Close the database connection for the selected data source or data sources. : : : : Available for: Data sources with active connections and their elements. ![the Jump to Query Console icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.sqlScript.svg) : Jump to Query Console… `Ctrl+Shift+F10` (Windows), `⌘ ⇧ F10` (macOS), `⌘ ⇧ F10` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ F10` (macOS System Shortcuts), `Ctrl+Shift+F10` (XWin), `Ctrl+Shift+F10` (GNOME), `Ctrl+Shift+F10` (KDE), `Ctrl+Shift+F10` (Emacs), `Ctrl+Shift+F10` (Sublime Text), `⌘ ⇧ F10` (Sublime Text (macOS)), `Ctrl+Shift+F10` (NetBeans), `Ctrl+Shift+F10` (Visual Studio), `⌘ ⇧ F10` (Visual Studio (macOS)), `Ctrl+Shift+F10` (Eclipse), `⌘ ⇧ F10` (Eclipse (macOS)) : : Open the list of [query consoles](query-consoles.html) for the selected data source. : : : : Available for: Data sources and their elements. ![the Edit Data icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.editData.svg) : Edit Data `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)) : : Open a table view of the object in the data editor. This option works for tables, views, and materialized views. : : : : Available for: Corresponding elements in data sources. `DDL` : Go to DDL `Ctrl+B` (Windows), `⌘ B` (macOS), `⌘ B` (IntelliJ IDEA Classic (macOS)), `⌘ B` (macOS System Shortcuts), `Ctrl+B` (XWin), `Ctrl+B` (GNOME), `Ctrl+B` (KDE), `Ctrl+Alt+G` (Emacs), `F12` (Sublime Text), `F12` (Sublime Text (macOS)), `Ctrl+B` (NetBeans), `F12` (Visual Studio), `F12` (Visual Studio (macOS)), `F3` (Eclipse), `F3` (Eclipse (macOS)) : : Open the DDL script of the selected object. : : : : For example, if you press this shortcut on a table's name in the `SELECT` statement, you will see the DDL of this table (the `CREATE TABLE` statement). : : : : ![Go to Declaration](https://resources.jetbrains.com/help/img/idea/2026.2/db_goto_declaration.png) : : > **Note:** : > The object references in the generated script are not qualified (for example, `` instead of `.`). You can view this script, edit it, and submit your changes to the database. : > : > : > : > For a runnable DDL script that includes `CREATE OR REPLACE`, qualified references, and so on, use the [SQL Generator](export-data.html#generate-ddl-definitions-for-dat). : : : : Available for: Corresponding elements in data sources. ![the Compare Structure icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.vcs.diff.svg) : Compare Schema Structure `Ctrl+D` (Windows), `⌘ D` (macOS), `⌘ D` (IntelliJ IDEA Classic (macOS)), `⌘ D` (macOS System Shortcuts), `Ctrl+D` (XWin), `Ctrl+D` (GNOME), `Ctrl+D` (KDE), `Ctrl+D` (Emacs), `Ctrl+D` (Sublime Text), `⌘ D` (Sublime Text (macOS)), `Ctrl+D` (NetBeans), `Ctrl+D` (Visual Studio), `⌘ D` (Visual Studio (macOS)), `Ctrl+D` (Eclipse), `⌘ D` (Eclipse (macOS)) : : Compare the structure of two database objects in the Migration [dialog](schema-comparison-and-migration.html#controls_of_the_migration_dialog). The comparison results are shown in the Diff Viewer. : : : : Available for: Two selected database objects of the same kind. ![](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) : View Options : : : : Open the list of database object tree viewing options, including the item filter. For more information about the options, refer to the [View Options](#view_options) chapter. : : : : Available for: All items. #### View Options The view options, generally, define what is shown in the tool window and how. To view or change these options, click ![](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.general.show.svg) View Options on the toolbar. ![the Filter icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.filter.svg) Filter : Open a list of database objects that you can filter. The list of database objects depends on the selected database. To see a full list of available database objects and their icons, go to [Icons for data sources and their elements](#icons-for-data-sources-and-their-elements). : : The green dot in the corner of filter icon indicates that the filter is on and some objects are filtered out. : : : : Filtered: : : : Everything is filtered out except views and tables : : : : ![Only views and tables are selected to view in Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/database_tool_window_items_filter_on.png) : : Not filtered: : : : Nothing is filtered out : : : : ![All items are selected to view in Database tool window](https://resources.jetbrains.com/help/img/idea/2026.2/database_tool_window_items_filter_off.png) `View in Groups | Databases and Schemas` : Displays folders for databases and schemas. `View in Groups | Server and Database Objects` : Displays folders for server and database objects, Server Objects and Database Objects correspondingly. This setting concerns users, roles, tablespaces, modules, foreign data wrappers, and other rarely used objects. `View in Groups | Object Elements` : This option defines how table elements are shown. : : : : * When on, there are separate nodes for columns, indexes, primary and foreign key constraints, and triggers (shown as folders). The elements appear in the corresponding groups. : : * When off, there is no such grouping and, generally, only columns are shown for tables. `View in Groups | Schema Objects` : Defines how schema elements are shown. : : : : * When on, there are separate nodes for tables, views, and stored routines (shown as folders). Tables, views and routines (procedures and functions) are shown as elements of the corresponding groups. : : * When off, there is no explicit grouping for tables, views, and routines. Tables and views are followed by procedures and functions. `View in Groups | Schema Objects by Prefix` : Group schema objects by prefix in their names. The following characters are treated as prefix delimiters: `_`, `-`, and `$`. `View in Groups | Separate Procedures and Functions` : In Microsoft SQL Server, Oracle, and PostgreSQL, separates procedures and functions into different folders. `View in Groups | Place Constraints and Similar Objects under Schema` : Display nodes for object names that exist in a schema namespace. For example, nodes for keys, `CHECK` constraints, indexes, triggers, rules, and other objects. : : : : You can use this option in the following situations: : : : : * To find an object inside a schema with the help of a quick search. : : * To see the columns under the table node. To do this, turn off the Empty Groups. `View in Groups | Sort Alphabetically` : Order database objects alphabetically. When the option is disabled, the natural sort order is applied. `Show Elements | All Namespaces` : Show all databases and schemes even if they are not selected for introspection. : : : : * When the All Namespaces option is disabled, the databases that are not selected for introspection do not appear in the Database tool window . : : * When the All Namespaces option is enabled, the databases that are not selected for introspection are displayed in the Database tool window . `Show Elements | Empty Groups` : If the [Schema Objects](#group_schema) or [Object Elements](#group_contents) options are selected, you can select to show or hide the categories that contain no elements. `Show Elements | Intermediate Nodes` : Shows or hides parent nodes only when you do not have other objects on the same level with a parent. `Show Elements | Generated Objects` : For Oracle, shows or hides auto-generated objects in the tree. It concerns the following objects: : : : : * Materialized view logs : : * The underlying tables for materialized views : : * Secondary tables `Show Elements | Virtual Objects` : Shows or hides the following objects: : : : : * Virtual foreign keys : : * Virtual views : : * Virtual columns `Show Elements | Query Files` : Shows or hides the Query Files folders under data source nodes. The folders contain the attached query files. `Node details | Comments Instead of Details` : Display comments for database objects. `Node details | Schema Refresh Time` : Display the local date and time of the last performed introspection for schemas. : : : : The feature is currently not supported for ClickHouse, Redis, Apache Cassandra, and Apache Hive. ### Context menu Context-menu actions appear when you right-click an object in the Database tool window . ![the Properties icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.manageDataSources.svg) Properties `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) : Open the [Data Sources and Drivers : dialog](data-sources-and-drivers-dialog.html) to manage your data sources and their settings. : : : : Available for: Data source and DDL data source nodes. ![the New icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.add.svg) New : Create a new data source, role, database, schema, query console, table, column, index, a primary, or a foreign key. The list of options depends on which element is currently selected. : : : : Available for: Data sources and database objects. : : : : Database objects creation is available only with the Ultimate subscription. `Copy/Paste | Copy Data Source` `Ctrl+C` (Windows), `⌘ C` (macOS), `⌘ C` (IntelliJ IDEA Classic (macOS)), `⌘ C` (macOS System Shortcuts), `Ctrl+C` (XWin), `Ctrl+C` (GNOME), `Ctrl+C` (KDE), `Ctrl+Insert` (Emacs), `Ctrl+C` (Sublime Text), `⌘ C` (Sublime Text (macOS)), `Ctrl+C` (NetBeans), `Ctrl+C` (Visual Studio), `⌘ C` (Visual Studio (macOS)), `Ctrl+C` (Eclipse), `⌘ C` (Eclipse (macOS)) : Copy the XML code snippet with connection settings to the clipboard. : : : : Available for: Data source nodes. `Copy/Paste | Copy Reference` `Ctrl+Alt+Shift+C` (Windows), `⌘ ⌥ ⇧ C` (macOS), `⌘ ⌥ ⇧ C` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ ⇧ C` (macOS System Shortcuts), `Ctrl+Alt+Shift+C` (XWin), `Ctrl+Alt+Shift+C` (GNOME), `Ctrl+Alt+Shift+C` (KDE), `Ctrl+Alt+Shift+C` (Emacs), `Ctrl+Alt+Shift+C` (Sublime Text), `⌘ ⌥ ⇧ C` (Sublime Text (macOS)), `Ctrl+Alt+Shift+C` (NetBeans), `Ctrl+Alt+Shift+C` (Visual Studio), `⌘ ⌥ ⇧ C` (Visual Studio (macOS)), `Ctrl+Alt+Shift+C` (Eclipse), `⌘ ⌥ ⇧ C` (Eclipse (macOS)) : Copy the fully qualified name of the selected item to the clipboard. : : : : Available for: Data sources and their elements. `Copy/Paste | Duplicate` `Ctrl+D` (Windows), `⌘ D` (macOS), `⌘ D` (IntelliJ IDEA Classic (macOS)), `⌘ D` (macOS System Shortcuts), `Ctrl+D` (XWin), `Ctrl+D` (GNOME), `Ctrl+D` (KDE), `Meta+D` (Emacs), `Ctrl+Shift+D` (Sublime Text), `⌘ ⇧ D` (Sublime Text (macOS)), `Ctrl+D` (NetBeans), `Ctrl+D` (Visual Studio), `⌘ D` (Visual Studio (macOS)), `Ctrl+D` (Eclipse), `Ctrl+D` (Eclipse (macOS)) : Create a copy of the selected data source. Specify the properties of the data source in the Data Sources and Drivers dialog that opens. : : : : Available for: Data source and DDL data source nodes. ![the Edit Data icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.editData.svg) Edit Data `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)) : Open a table view of the object in the data editor. This option works for tables, views, and materialized views. : : : : Available for: Corresponding elements in data sources. To Folder… `F6` (Windows), `F6` (macOS), `F6` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ I` (macOS System Shortcuts), `F6` (XWin), `F6` (GNOME), `F6` (KDE), `F6` (Emacs), `F6` (Sublime Text), `F6` (Sublime Text (macOS)), `Ctrl+M` (NetBeans), `Ctrl+R, O` (Visual Studio), `⌘ R, O` (Visual Studio (macOS)), `Alt+Shift+V` (Eclipse), `⌘ ⌥ V` (Eclipse (macOS)) : Move the selected data source to a folder. If no folders exist yet, create the first one in the Move to Folder popup that appears. : : : : For more information about grouping data sources, refer to [Group data sources in folders](managing-data-sources.html#group-data-sources-in-folders). : : : : Available for: Data source and DDL data source nodes. ![the Refresh icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.general.refresh.svg) Refresh `Ctrl+F5` (Windows), `⌘ R` (macOS), `⌃ F5` (IntelliJ IDEA Classic (macOS)), `⌘ R` (macOS System Shortcuts), `Ctrl+F5` (XWin), `Ctrl+F5` (GNOME), `Ctrl+5` (KDE), `Ctrl+F5` (Emacs), `Ctrl+F5` (Sublime Text), `⌘ R` (Sublime Text (macOS)), `Ctrl+F5` (NetBeans), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)) : Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). : : : : See also, [Data Sources and Drivers dialog](data-sources-and-drivers-dialog.html#auto_sync). : : : : Available for: Data sources and their elements. ![the Deactivate icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.killDataSourceProcess.svg) Deactivate `Ctrl+F2` (Windows), `⌘ F2` (macOS), `⌘ F2` (IntelliJ IDEA Classic (macOS)), `⌃ ⇧ .` (macOS System Shortcuts), `Ctrl+F2` (XWin), `Ctrl+F2` (GNOME), `Ctrl+2` (KDE), `Ctrl+F2` (Emacs), `Ctrl+F2` (Sublime Text), `Ctrl+F2` (Sublime Text (macOS)), `Shift+F5` (NetBeans), `Shift+F5` (Visual Studio), `⇧ F5` (Visual Studio (macOS)), `Ctrl+F2` (Eclipse), `⌘ F2` (Eclipse (macOS)) : Close the database connection for the selected data source or data sources. : : : : Available for: Data sources with active connections and their elements. Quick Documentation `Ctrl+Q` (Windows), `F1` (macOS), `⌃ J` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Ctrl+Q` (XWin), `Ctrl+Q` (GNOME), `Ctrl+Q` (KDE), `Ctrl+Q` (Emacs), `Ctrl+Q` (Sublime Text), `Ctrl+Q` (Sublime Text (macOS)), `Ctrl+Q` (NetBeans), `Ctrl+K, I` (Visual Studio), `⌘ K, I` (Visual Studio (macOS)), `Alt+Middle-Click` (Eclipse), `⌥ Middle-Click` (Eclipse (macOS)) : View basic information about the selected element. : : : : To close the documentation popup, press `Escape` (Windows), `⎋` (macOS), `⎋` (IntelliJ IDEA Classic (macOS)), `⎋` (macOS System Shortcuts), `Escape` (XWin), `Escape` (GNOME), `Escape` (KDE), `Escape, Escape` (Emacs), `Escape` (Sublime Text), `⎋` (Sublime Text (macOS)), `Escape` (NetBeans), `Escape` (Visual Studio), `⎋` (Visual Studio (macOS)), `Escape` (Eclipse), `⎋` (Eclipse (macOS)). : : : : Available for: Data sources and their elements. : : : : For more information about quick documentation, refer to [quick documentation](viewing-reference-information.html#inline-quick-documentation). ![the Compare Structure icon](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.vcs.diff.svg) Compare Structure With `Ctrl+D` (Windows), `⌘ D` (macOS), `⌘ D` (IntelliJ IDEA Classic (macOS)), `⌘ D` (macOS System Shortcuts), `Ctrl+D` (XWin), `Ctrl+D` (GNOME), `Ctrl+D` (KDE), `Ctrl+D` (Emacs), `Ctrl+D` (Sublime Text), `⌘ D` (Sublime Text (macOS)), `Ctrl+D` (NetBeans), `Ctrl+D` (Visual Studio), `⌘ D` (Visual Studio (macOS)), `Ctrl+D` (Eclipse), `⌘ D` (Eclipse (macOS)) : Compare the structure of two database objects in the Migration [dialog](schema-comparison-and-migration.html#controls_of_the_migration_dialog). The comparison results are shown in the Diff Viewer. : : : : Available for: Two selected database objects of the same kind. `Navigation | Go to DDL` `Ctrl+B` (Windows), `⌘ B` (macOS), `⌘ B` (IntelliJ IDEA Classic (macOS)), `⌘ B` (macOS System Shortcuts), `Ctrl+B` (XWin), `Ctrl+B` (GNOME), `Ctrl+B` (KDE), `Ctrl+Alt+G` (Emacs), `F12` (Sublime Text), `F12` (Sublime Text (macOS)), `Ctrl+B` (NetBeans), `F12` (Visual Studio), `F12` (Visual Studio (macOS)), `F3` (Eclipse), `F3` (Eclipse (macOS)) : Open the DDL script of the selected object. : : : : For example, if you press this shortcut on a table's name in the `SELECT` statement, you will see the DDL of this table (the `CREATE TABLE` statement). : : : : ![Go to Declaration](https://resources.jetbrains.com/help/img/idea/2026.2/db_goto_declaration.png) : : > **Note:** : > The object references in the generated script are not qualified (for example, `` instead of `.`). You can view this script, edit it, and submit your changes to the database. : > : > : > : > For a runnable DDL script that includes `CREATE OR REPLACE`, qualified references, and so on, use the [SQL Generator](export-data.html#generate-ddl-definitions-for-dat). : : : : Available for: Corresponding elements in data sources. `Navigation |` Jump to Query Console… `Ctrl+Shift+F10` (Windows), `⌘ ⇧ F10` (macOS), `⌘ ⇧ F10` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ F10` (macOS System Shortcuts), `Ctrl+Shift+F10` (XWin), `Ctrl+Shift+F10` (GNOME), `Ctrl+Shift+F10` (KDE), `Ctrl+Shift+F10` (Emacs), `Ctrl+Shift+F10` (Sublime Text), `⌘ ⇧ F10` (Sublime Text (macOS)), `Ctrl+Shift+F10` (NetBeans), `Ctrl+Shift+F10` (Visual Studio), `⌘ ⇧ F10` (Visual Studio (macOS)), `Ctrl+Shift+F10` (Eclipse), `⌘ ⇧ F10` (Eclipse (macOS)) : Open the list of [query consoles](query-consoles.html) for the selected data source. : : : : Available for: Data sources and their elements. ![](https://resources.jetbrains.com/help/img/idea/2026.2/app.expui.run.run.svg) Run Function or Run Procedure : Run the selected function or procedure. : : : : Available for: Data source elements: functions, procedures. Introspection Level : Change the [introspection level](introspection-levels.html) either for the whole database or for a particular schema. Children inherit a level that is set for a parent. : : : : Available for: Data Source nodes. `SQL Scripts | SQL Generator…` `Ctrl+Alt+G` (Windows), `⌘ ⌥ G` (macOS), `⌘ ⌥ G` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ G` (macOS System Shortcuts), `Ctrl+Alt+G` (XWin), `Ctrl+Alt+G` (GNOME), `Ctrl+Alt+G` (KDE), `Ctrl+Alt+G` (Emacs), `Ctrl+Alt+G` (Sublime Text), `⌘ ⌥ G` (Sublime Text (macOS)), `Ctrl+Alt+G` (NetBeans), `Ctrl+Alt+G` (Visual Studio), `⌘ ⌥ G` (Visual Studio (macOS)), `Ctrl+Alt+G` (Eclipse), `⌘ ⌥ G` (Eclipse (macOS)) : Generate data definition structures for database objects. For example, you can generate DDL files for a single table or for all the tables in the schema. Also, you can customize generation settings. For example, you can set what syntax to use for table creation: `CREATE TABLE` or `CREATE TABLE IF NOT EXISTS`. : : : : Available for: Data source elements. : : : : For more information about using SQL Generator, refer to the [Generate DDL definitions for database objects](export-data.html#generate-ddl-definitions-for-dat) and [Change output settings of the SQL Generator](export-data.html#change-output-settings-of-the-sql-generator) chapters. : : : : Available only with the Ultimate subscription. `SQL Scripts | Request and Copy Original DDL` : Requests the DBMS server to get or generate a source text for this object, receives this text, and puts it to the clipboard. : : : : Available for: Data sources and their elements. `SQL Scripts | Generate DDL to Clipboard` `Ctrl+Alt+Shift+G` (Windows), `⌘ ⌥ ⇧ G` (macOS), `⌘ ⌥ ⇧ G` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ ⇧ G` (macOS System Shortcuts), `Ctrl+Alt+Shift+G` (XWin), `Ctrl+Alt+Shift+G` (GNOME), `Ctrl+Alt+Shift+G` (KDE), `Ctrl+Alt+Shift+G` (Emacs), `Ctrl+Alt+Shift+G` (Sublime Text), `⌘ ⌥ ⇧ G` (Sublime Text (macOS)), `Ctrl+Alt+Shift+G` (NetBeans), `Ctrl+Alt+Shift+G` (Visual Studio), `⌘ ⌥ ⇧ G` (Visual Studio (macOS)), `Ctrl+Alt+Shift+G` (Eclipse), `⌘ ⌥ ⇧ G` (Eclipse (macOS)) : Generate a DDL of the object and copy it to the clipboard. : : : : Available for: Data sources and their elements. : : : : Available only with the Ultimate subscription. `SQL Scripts | Generate DDL to Query Console` `Ctrl+Alt+Shift+B` (Windows), `⌘ ⌥ ⇧ B` (macOS), `⌘ ⌥ ⇧ B` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ ⇧ B` (macOS System Shortcuts), `Ctrl+Alt+Shift+B` (XWin), `Ctrl+Alt+Shift+B` (GNOME), `Ctrl+Alt+Shift+B` (KDE), `Ctrl+Alt+Shift+B` (Emacs), `Ctrl+Alt+Shift+B` (Sublime Text), `⌘ ⌥ ⇧ B` (Sublime Text (macOS)), `Ctrl+Alt+Shift+B` (NetBeans), `Ctrl+Alt+Shift+B` (Visual Studio), `⌘ ⌥ ⇧ B` (Visual Studio (macOS)), `Ctrl+Alt+Shift+B` (Eclipse), `⌘ ⌥ ⇧ B` (Eclipse (macOS)) : Generate a DDL of the object and copy it to the query console. : : : : Available for: Data sources and their elements. : : : : Available only with the Ultimate subscription. `Object Actions | Rename…` `Shift+F6` (Windows), `⇧ F6` (macOS), `⇧ F6` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ R` (macOS System Shortcuts), `Shift+F6` (XWin), `Shift+F6` (GNOME), `Shift+F6` (KDE), `Shift+F6` (Emacs), `Shift+F6` (Sublime Text), `⇧ F6` (Sublime Text (macOS)), `Ctrl+R` (NetBeans), `Ctrl+R, R` (Visual Studio), `⌘ R, R` (Visual Studio (macOS)), `Alt+Shift+R` (Eclipse), `⇧ F6` (Eclipse (macOS)) : Rename the selected item. Specify the new name in the dialog that opens. : : : : Available for: Data sources and their elements. : : : : Available only with the Ultimate subscription. `Object Actions | Enable triggers/constraints` : Enable triggers and constraints for the selected table. : : : : Available for: Data source elements: tables. : : : : Available only with the Ultimate subscription. `Object Actions | Disable triggers/constraints` : Disable triggers and constraints for the selected table. : : : : Available for: Data source elements: tables. : : : : Available only with the Ultimate subscription. `Object Actions | Modify Comment` : Modify the database object comment in the Modify Comment dialog. : : : : Available only with the Ultimate subscription. `Object Actions | Modify Grants` : Modify the grants of a database object in the Modify Grants of dialog. : : : : Available only with the Ultimate subscription. `Object Actions | Truncate…` : Remove all the rows in the selected table. : : : : Available for: Data source elements: tables. : : : : Available only with the Ultimate subscription. `Object Actions | Drop…` or `Object Actions | Remove Data Source` `Delete` (Windows), `⌦` (macOS), `⌦` (IntelliJ IDEA Classic (macOS)), `⌦` (macOS System Shortcuts), `Delete` (XWin), `Delete` (GNOME), `Delete` (KDE), `Delete` (Emacs), `Delete` (Sublime Text), `⌦` (Sublime Text (macOS)), `Delete` (NetBeans), `Delete` (Visual Studio), `⌦` (Visual Studio (macOS)), `Delete` (Eclipse), `⌦` (Eclipse (macOS)) : Remove the selected item. : : : : Available for: Data sources and their elements. : : : : Available only with the Ultimate subscription. `Tools | Manage Shown Schemas…` : Open a popup with available schemas for the current data source. : : : : See also, [Show and hide schemas](schemas.html#show_hide_schemas_and_databases). : : : : Available for: Data sources and their elements. `Tools | Full-text Search` `Shift+Ctrl+Alt+F` (Windows), `Shift+Ctrl+Alt+F` (macOS), `Shift+Ctrl+Alt+F` (IntelliJ IDEA Classic (macOS)), `Shift+Ctrl+Alt+F` (macOS System Shortcuts), `Shift+Ctrl+Alt+F` (XWin), `Shift+Ctrl+Alt+F` (GNOME), `Shift+Ctrl+Alt+F` (KDE), `Shift+Ctrl+Alt+F` (Emacs), `Shift+Ctrl+Alt+F` (Sublime Text), `Shift+Ctrl+Alt+F` (Sublime Text (macOS)), `Shift+Ctrl+Alt+F` (NetBeans), `Shift+Ctrl+Alt+F` (Visual Studio), `Shift+Ctrl+Alt+F` (Visual Studio (macOS)), `Shift+Ctrl+Alt+F` (Eclipse), `Shift+Ctrl+Alt+F` (Eclipse (macOS)) : Search for data in your databases or a group of databases without knowing the data's exact location. : : : : Available for: Data sources and their elements. : : : : For more information about the full-text search, refer to [Full-text search in databases](full-text-search-for-databases.html). `Tools | Add Bookmark` `F11` (Windows), `F3` (macOS), `F11` (IntelliJ IDEA Classic (macOS)), `⌃ ⇧ K` (macOS System Shortcuts), `F11` (XWin), `F11` (GNOME), `F11` (KDE), `F11` (Emacs), `Ctrl+F2` (Sublime Text), `⌘ F2` (Sublime Text (macOS)), `F11` (NetBeans), `Ctrl+K, K` (Visual Studio), `⌘ K, K` (Visual Studio (macOS)), `Ctrl+Shift+F11` (Eclipse), `F11` (Eclipse (macOS)) : Add the selected item to bookmarks. : : : : Available for: Data sources and their elements. `Tools | Scripted Extensions | Generate POJOs.clj` : Generate a Java entity class for the selected table. In the dialog that opens, specify the directory in which the JAVA class file should be generated. : : : : Available for: Data sources and their elements. `Tools | Scripted Extensions | Go To Scripts Directory` : Switch to the directory where the`Generate POJOs.clj`example script file is located. : : : : Available for: Data sources and their elements. `Import/Export | Export Data to File` : Save data for the selected tables and views in files. Select the output format (for example, SQL Inserts, Tab-separated (TSV), JSON-Clojure.json.clj). : : : : Available for: Data source elements: tables and views. `Import/Export | Import Data from File(s)…` : Import a text file containing delimiter-separated values (CSV, TSV, and so on) into your database. : : : : If a schema is currently selected, IntelliJ IDEA will create a new table for the data that you are importing. If a table is selected, IntelliJ IDEA will try to add the data to the selected table. : : : : Available for: Database tables. `Import/Export | Copy Table to` `F5` (Windows), `F5` (macOS), `F5` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ Y` (macOS System Shortcuts), `F5` (XWin), `F5` (GNOME), `F5` (KDE), `F5` (Emacs), `F5` (Sublime Text), `F5` (Sublime Text (macOS)), `F5` (NetBeans), `F5` (Visual Studio), `F5` (Visual Studio (macOS)), `F5` (Eclipse), `F5` (Eclipse (macOS)) : Create a copy of the selected table. You can create a copy in a different scheme or data source. For example, you can copy the `actor` table from MySQL to PostgreSQL. : : : : Available for: Database tables and views. `Import/Export | Dump to DDL Data Source` : Create your DDL data source by dumping a regular data source to a root/repository folder. : : : : Available for: Data sources and their elements. `Import/Export | Export with 'mysqldump'…` or `Import/Export | Export with 'pg_dump'…` : Run mysqldump or pg_dump for the selected items. mysqldump and pg_dump are native MySQL and PostgreSQL tools. They are not integrated into IntelliJ IDEA. You can read about them at [dev.mysql.com](http://dev.mysql.com/) and [postgresql.org](https://www.postgresql.org/). : : : : Available for: Data source nodes. `Import/Export | Restore with 'mysql'…` or `Import/Export | Restore with 'psql'…` or Restore : Run mysql, pg_restore, or psql to restore a data dump. These tools are native for MySQL and PostgreSQL. They are not integrated into IntelliJ IDEA. You can read about them at [dev.mysql.com](http://dev.mysql.com/) and [postgresql.org](https://www.postgresql.org/). : : : : Available for: Data source nodes. `Diagrams | Show Diagram` `Ctrl+Alt+Shift+U` (Windows), `⌘ ⌥ ⇧ U` (macOS), `⌘ ⌥ ⇧ U` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ ⇧ U` (macOS System Shortcuts), `Ctrl+Alt+Shift+U` (XWin), `Ctrl+Alt+Shift+U` (GNOME), `Ctrl+Alt+Shift+U` (KDE), `Ctrl+Alt+Shift+U` (Emacs), `Ctrl+Alt+Shift+U` (Sublime Text), `⌘ ⌥ ⇧ U` (Sublime Text (macOS)), `Ctrl+Alt+Shift+U` (NetBeans), `Ctrl+Alt+Shift+U` (Visual Studio), `⌘ ⌥ ⇧ U` (Visual Studio (macOS)), `Ctrl+Alt+Shift+U` (Eclipse), `⌘ ⌥ ⇧ U` (Eclipse (macOS)) : View a UML class diagram for the selected data source or table in a separate editor tab. : : : : Available for: Data sources and their elements. `Diagrams | Show Diagram Popup` `Ctrl+Alt+U` (Windows), `⌘ ⌥ U` (macOS), `⌘ ⌥ U` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ U` (macOS System Shortcuts), `Ctrl+Alt+U` (XWin), `Ctrl+Alt+U` (GNOME), `Ctrl+Alt+U` (KDE), `Ctrl+Alt+U` (Emacs), `Ctrl+Alt+U` (Sublime Text), `⌘ ⌥ U` (Sublime Text (macOS)), `Ctrl+Alt+U` (NetBeans), `Ctrl+Alt+U` (Visual Studio), `⌘ ⌥ U` (Visual Studio (macOS)), `Ctrl+Alt+U` (Eclipse), `⌘ ⌥ U` (Eclipse (macOS)) : View a UML class diagram for the selected data source or table in a popup. : : : : Available for: Data sources and their elements. `Diagnostics | Dump Metadata Model` : Generate a diagnostic representation of the database in a IntelliJ IDEA internal format. This information might be helpful for the support team if some database objects exist in the database but do not show up in the Database tool window . : : : : Available for: Data sources and their elements. `Diagnostics | Generate Introspector Diagnostic Files` : Generate three files that include information about the following: : : : : * `dataSource.txt`: the data source. : : * `introspector.txt`: a module that was used to load the metadata from the database. : : * `model.xml`: a part of the database model. : : : : This information is helpful when introspection works incorrectly. : : : : Available for: Data sources and their elements. `Diagnostics | Show JDBC Log Settings…` : Open the JDBC Log Setting [dialog](null) to configure the JDBC driver log settings. : : : : Available for: Data sources and their elements. `Diagnostics | Force Refresh` `Ctrl+Shift+F5` (Windows), `⌘ ⌥ ⇧ R` (macOS), `⌃ ⇧ F5` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ ⇧ R` (macOS System Shortcuts), `Ctrl+Shift+F5` (XWin), `Ctrl+Shift+F5` (GNOME), `Ctrl+Shift+5` (KDE), `Ctrl+Shift+F5` (Emacs), `Ctrl+Shift+F5` (Sublime Text), `⌘ ⌥ ⇧ R` (Sublime Text (macOS)), `Ctrl+Shift+F5` (NetBeans), `Ctrl+Shift+F5` (Visual Studio), `⌘ ⌥ ⇧ R` (Visual Studio (macOS)), `Ctrl+Shift+F5` (Eclipse), `Ctrl+Shift+F5` (Eclipse (macOS)) : Delete the data source information from cache and load it again. This action is available on the data source node only. : : : : Available for: Data source nodes. `Diagnostics | Forget This Schema Cache` : Delete the information that IntelliJ IDEA has accumulated about your database. This action is available on the data source node only. : : : : Use this command when you experience issues like wrong display of data structures or errors during synchronization. : : : : To check if this has eliminated the problem, use the [Synchronize command](#sync). : : : : Available for: Data source nodes. `Diagnostics | Diagnostic Mode` : Enables the diagnostic mode where IntelliJ IDEA writes the introspection log. : : : : You can access the log file by clicking the link in the Diagnostic log started and Diagnostic log stopped notification popups that appear once you enable and disable the mode. : : : : ![Notification about the log file](https://resources.jetbrains.com/help/img/idea/2026.2/db_data_source_diagnostic_log_notification.png) ### Icons #### Data sources and their elements | Icon | Description | | --- | --- | | ![Access Method](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.accessMethod.svg) | Access Method | | ![Aggregate](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.aggregate.svg) | Aggregate | | ![Alias Type](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.nodes.type.svg) | Alias Type | | ![Argument](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.argument.svg) | Argument | | ![Body](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.body.svg) | Body | | ![Check](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.checkConstraint.svg) | Check | | ![Cluster](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.unspecifiedCluster.svg) | Cluster | | ![Collation](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.collation.svg) | Collation | | ![Collection Type](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.collectionType.svg) | Collection Type | | ![Column](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.column.svg) | Column. For more information about column icon combinations, refer to [Possible icon combinations for columns](#possible-icon-combinations-for-columns). | | ![Data File](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.dataFile.svg) | Data File | | ![Database](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.database.svg) | Database | | ![Read-only](https://resources.jetbrains.com/help/img/idea/2026.2/app.ide.readonly.svg) | Read-only status | | ![the DDL data source icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.ddlDbms.svg) | DDL data source | | ![Default](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.defaultConstraint.svg) | Default | | ![Exception](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.nodes.exception.svg) | Exception | | ![Extension](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.extension.svg) | Extension | | ![External Schema](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.externalSchema.svg) | External Schema | | ![Foreign Data Wrapper](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.foreignDatawrapper.svg) | Foreign Data Wrapper | | ![Foreign Key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.blueKey.svg) | Foreign Key | | ![Foreign Table](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.foreignTable.svg) | Foreign Table | | ![Index](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.index.svg) | Index | | ![Key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.greyKey.svg) | Key | | ![Materialized Log](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.materializedLog.svg) | Materialized Log | | ![Materialized View](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.materializedView.svg) | Materialized View | | ![Object Attribute](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.objectTypeAttribute.svg) | Object Attribute | | ![Object Type](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.nodes.type.svg) | Object Type | | ![Operator](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.operator.svg) | Operator | | ![Package](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.package.svg) | Package | | ![Primary Key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.goldKey.svg) | Primary key | | ![Projection](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.projection.svg) | Projection | | ![Data source](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.dbms.svg) | Data sources | | ![Role](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.role.svg) | Role | | ![Routine](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.routine.svg) | Routine | | ![Rule](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.fileTypes.config.svg) | Rule | | ![Scheduled Event](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.scheduledEvent.svg) | Scheduled Event | | ![Schema](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.schema.svg) | Schema | | ![Sequence](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.sequence.svg) | Sequence | | ![Server](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.foreign_server.svg) | Server | | ![the Stored procedure or function icon](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.function.svg) | Stored procedure or function | | ![Synonym](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.synonym.svg) | Synonym | | ![Table](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.table.svg) | Table | | ![Table Type](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.nodes.type.svg) | Table Type | | ![Tablespace](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.tablespace.svg) | Tablespace | | ![Trigger](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.trigger.svg) | Trigger | | ![User](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.user.svg) | User | | ![User Mapping](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.userMapping.svg) | User Mapping | | ![Variable](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.nodes.variable.svg) | Variable | | ![View](https://resources.jetbrains.com/help/img/idea/2026.2/app-client.expui.gutter.dataSchema.svg) | View | | ![Virtual column](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.virtualColumn.svg) | Virtual column | | ![Virtual foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.virtualForeignKey.svg) | Virtual foreign key | | ![Virtual view](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.virtualView.svg) | Virtual view | | ![Virtual Table](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.table.svg) | Virtual Table | #### Possible icon combinations for columns | Icon | Foreign key | Primary key | Indexed | NOT NULL | | --- | --- | --- | --- | --- | | ![Column](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.column.svg) | | | | | | ![Column with a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnBlueKey.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | | | ![Column with a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldKey.svg) | | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | | ![Indexed column](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnIndex.svg) | | | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | ![Column that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnDot.svg) | | | | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed column that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnDotIndex.svg) | | | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed column with primary and foreign keys that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldBlueKeyDotIndex.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed column with primary and foreign keys](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldBlueKeyIndex.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | ![Column with primary and foreign keys that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldBlueKeyDot.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Column with primary and foreign keys](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldBlueKey.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | | ![Indexed column with a foreign key that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnBlueKeyDotIndex.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Column with a foreign key that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnBlueKeyDot.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed column with a foreign key that accepts NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnBlueKeyIndex.svg) | ![Has a foreign key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | | ![Indexed column with a primary key that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldKeyDotIndex.svg) | | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Column with a primary key that does not accept NULL values](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldKeyDot.svg) | | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Has the NOT NULL constraint](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ![Indexed column with a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/database-plugin.icons.expui.columnGoldKeyIndex.svg) | | ![Has a primary key](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | ![Indexed](https://resources.jetbrains.com/help/img/idea/2026.2/app.actions.checked.svg) | | ## See also ### Getting Started [Tool windows](tool-windows.html) ### Procedures [Database Tools and SQL](relational-databases.html) [Data sources](managing-data-sources.html)