How To Add Database Tool Window In Intellij

Overview

In the Database tool window (), y'all tin work with databases and DDL information sources. You tin can view and modify data structures in your databases, and perform other associated tasks. To view a table, double-click the table. For more information nigh different viewing modes, see View data.

The available data sources are shown every bit a tree of information sources, schemas, tables and columns. If no information sources are currently divers, utilise the New command Alt+Insert to create a data source.

Most of the functions in this window are accessed past means of the toolbar icons or context menu commands. (If the toolbar is not currently shown, click on the title bar and select Show Toolbar.) Many of the commands have keyboard shortcuts. If the toolbar is hidden, the Refresh and Open up Query Console commands tin can be access past means of the championship bar icons ( and respectively).

Icon	Command	Shortcut	Description	Bachelor for
			Plummet all the nodes.	All node types
	New	Alt+Insert	Create a new information source, office, database, schema, query console, table, column, alphabetize, or a primary or a foreign key. The listing of options depends on which element is currently selected.	Information sources and their elements. If a DDL information source is selected, you can just choose to create another data source.
	Duplicate	Ctrl+D	Create a copy of the selected data source. Specify the properties of the data source in the Data Sources and Drivers dialog that opens.	DB and DDL data source nodes
	Refresh	Ctrl+F5	Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). Run across too, Data sources and drivers dialog.	data sources and their elements
	Data Source Properties		Open up the Data Sources and Drivers dialog to manage your data sources and their settings.	All node types
	Deactivate	Ctrl+F2	Close the database connectedness for the selected data source or data sources. (The names of the data sources with active database connections are shown in assuming.)	Data sources with active connections and their elements
	Edit Information	F4	Open a tabular array view of the object in the data editor. This choice works for tables, views, and materialized views.	Corresponding elements in information sources.
	Go to DDL	Ctrl+B	Open the DDL of the selected object. For case, if you printing this shortcut on a tabular array's proper noun in the SELECT statement, yous will meet the DDL of this tabular array (the CREATE Tabular array statement).	Corresponding elements in data sources.
	Jump to Query Console…	Ctrl+Shift+F10	Open up the default query console for the respective data source.	Data sources and their elements (tables and table columns)
	Filter		Open up a list of database objects that you can filter for the selected database. The listing of database objects depends on the selected database. To meet a full list of bachelor database objects and their icons, go to Icons for data sources and their elements.	Data sources and their elements

Context-carte deportment appear when y'all right-click an object in the Database tool window.

Control	Shortcut	Description
New		Create a new data source, part, database, schema, query console, tabular array, cavalcade, index, a primary or a foreign primal. The listing of options depends on which element is currently selected.
Rename	Shift+F6	Rename the selected data source, table or column. Specify the new name in the dialog that opens.
Modify Object… or Modify Table	Ctrl+F6	Edit the definition of a table, column, index, master or a foreign key.
Copy Reference	Ctrl+Alt+Shift+C	Copy the fully qualified name of the selected data source, table or column to the clipboard.
Quick Documentation	Ctrl+Q	View basic information virtually the selected element. To shut the documentation popup, printing Escape.
Detect Usages	Alt+F7	Detect all the usages or references of a data source, table, cavalcade, or any other selected detail in your source files and libraries.
Add to Favorites		Add an item to the Favorites listing. Y'all tin can quickly access those items in the Favorites tool window ().
	Ctrl+Alt+G	Generate data definition structures for database objects. For example, yous tin can generate DDL files for a unmarried tabular array or for all the tables in the schema. Likewise, you tin customize generation settings. For example, you can gear up what syntax to employ for table cosmos: CREATE Tabular array or CREATE Tabular array IF NOT EXISTS.
	Ctrl+Alt+G	If your database stores DDL of the object, retrieve DDL from the database.
	Ctrl+Alt+Shift+Thou	Generate DDL of the object and re-create it to the clipboard.
	Ctrl+Alt+Shift+B	Generate DDL of the object and paste it to a query console.
		Modify or add a comment to a database object like if you accept run the post-obit query COMMENT ON SCHEMA information_schema IS 'myComment';.
		Remove all the rows in the selected table.
		Open a popup with available schemas for the electric current data source.
		Hibernate the schema that is selected.
	Ctrl+Shift+F5	Delete the data source information from enshroud and load it again. This action is available on the information source node simply.
		Delete the information that IntelliJ IDEA has accumulated about your database. This action is bachelor on the data source node only. Use this control when you experience bug like incorrect brandish of data structures or errors during synchronization. To check if this has eliminated the trouble, employ the Synchronize command.
	Shift+Enter	Open the Information Sources and Drivers window where you lot can customize data source settings.
		Remove the primary key constraint for the current tabular array.
		Remove the strange central constraint.
		Generate an IntelliJ IDEA-specific representation of the database structure (a database model).
		Reload the metadata from the database and generate a LOG file. This information might exist helpful for the support squad when you think that your introspection is slow.
		Generate three files that include information about the data source (dataSource.txt), a module that was used to load the metadata from the database (introspector.txt), and a part of the database model (model.xml). This data might be helpful when introspection works incorrectly. For example, when yous see something outdated or exercise not see new objects.
Drop or Remove	Delete	Remove the selected item.
Jump to Query Console…	Ctrl+Shift+F10	Create and open a new query console for the selected data source.
Refresh	Ctrl+F5	Create and open up a new query console for the selected data source.
Compare…	Ctrl+D	Compare structures of two selected database objects (data sources, schemas, or tables). The comparing results are shown in the differences viewer.
Compare Content		Compare the output results of tables, views, and materialized views. The comparison results are shown in the differences viewer.
Export Data to &File		Relieve information for the selected tables and views in files. Select the output format (for case, SQL Inserts, Tab-separated (TSV), JSON-Clojure.json.clj).
Export with 'mysqldump' or Consign 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 tin can read almost them at dev.mysql.com and postgresql.org.
Import Data from File…		Import a text file containing delimiter-separated values (CSV, TSV, then on) into your database. If a schema is currently selected, IntelliJ IDEA volition create a new table for the data that you are importing. If a table is selected, IntelliJ IDEA will endeavor to add together the information to the selected tabular array.
Total-text Search	Shift+Ctrl+Alt+F	Search for information in your databases or a group of databases without knowing data exact location. For more information about the full-text search, see Full-text search in databases.
Restore with 'mysql' 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 non integrated into IntelliJ Idea. You can read almost them at dev.mysql.com and postgresql.org.
Copy Tabular array to…	F5	Create a copy of the selected tabular array. You tin create a copy in a different scheme or data source. For example, yous can copy the role player table from MySQL to PostgreSQL.
Color Settings…		Set or modify the colour for the selected element or elements. (The Database Color Settings dialog will open.) To set a color, right-click a data source and select Color Settings…. In the Database Color Settings dialog, select the dialog and coloring options. To accept the information source colour applied for query consoles and grids, select the In console editors and grids checkbox.
		Generate a Java entity form for the selected table. In the dialog that opens, specify the directory in which the JAVA class file should be generated.
		Switch to the directory where the Generate POJOs.clj example script file is located.
and	Ctrl+Alt+Shift+U and Ctrl+Alt+U	View a UML class diagram for the selected data source or tabular array. Yous can select betwixt the following options: Show Visualisation to open up the diagram on a separate editor tab. Show Visualisation Popup to run into the diagram in a popup.

View options

The view options, generally, define what is shown in the tool window and how. To view or change these options, click on the title bar.

Choice	Description
Group Data Sources	Displays folders for information sources if yous created any. Enabled Disabled
Grouping Server and Database Objects	Displays folders for server and database objects. This setting concerns users, roles, tablespaces, modules, strange data wrappers and other rarely-used objects. Enabled Disabled
Group 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.
Grouping Object Elements	This option defines how tabular array elements are shown. When on, at that place are separate nodes for columns, indexes, chief and strange key constraints, and triggers (shown as folders). The elements announced in the corresponding groups. When off, there is no such grouping and, generally, only columns are shown for tables.
Evidence All Namespaces	Show all databases and schemes fifty-fifty if they are non selected for introspection. When the Evidence All Namespaces option is disabled, databases that are non selected for introspection do non appear in the Database tool window. When the Bear witness All Namespaces option is enabled, databases that are not selected for introspection are displayed in the Database tool window.
Evidence Empty Groups	If the Group Schema Objects or Group Object Elements options are selected, you can select to show or hibernate the categories that contain no elements. The Bear witness Empty Groups selection is on: The Show Empty Groups pick is off:
Show Intermediate Nodes	Shows or hides parent nodes only when you do not have other objects on the same level with a parent. Enabled Disabled
Testify Generated Objects	For Oracle, shows or hides automobile-generated objects in the tree. It concerns the following objects: Materialized view logs The underlying tables for materialized views Secondary tables
Carve up Procedures and Functions	In Microsoft SQL Server, Oracle, and PostgreSQL, separates procedures and functions into different folders.
Sort Alphabetically	Order database objects alphabetically. When the option is disabled, natural sort lodge is applied. Sort Alphabetically is enabled Sort Alphabetically is disabled
Place Constraints and Similar Objects nether Schema	Display nodes for object names that be in a schema namespace. For example, nodes for keys, Bank check constraints, indexes, triggers, rules, and other objects. You lot can apply this choice in the post-obit situations: To detect an object inside a schema with the help of a quick search. To come across the columns but under the table node. To do this, turn off the Show Empty Groups. Enabled Disabled
Show Toolbar	Display the toolbar in the Database tool window.

The balance of the options are common for all the tool windows, run across Tool window view modes.

Icons for data sources and their elements

Icon	Clarification
	Access Method
	Amass
	Alias Type
	Statement
	Body
	Check
	Cluster
	Collation
	Collection Type
	Column. For more information about cavalcade icon combinations, run across Possible icon combinations for columns.
	Data File
	Database
	Read-only condition
	DDL information source
	Default
	Exception
	Extension
	External Schema
	Foreign Information Wrapper
	Strange Key
	Strange Table
	Alphabetize
	Key
	Materialized Log
	Materialized View
	Object Attribute
	Object Type
	Operator
	Package
	Projection
	Read-only information sources
	Function
	Routine
	Rule
	Scheduled Event
	Schema
	Sequence
	Server
	Stored procedure or role
	Synonym
	Table
	Table Type
	Tablespace
	Trigger
	User
	User Mapping
	Variable
	View
	Virtual Table

Possible icon combinations for columns

Icon	Foreign key	Master key	Indexed	NOT Nothing

Title bar context card and buttons

You lot tin can right-click the window title bar and use the context card to configure its viewing manner, acquaintance the window with a different tool window bar, or resize and hibernate the window.

You can also employ the toolbar buttons:

Item	Shortcut	Description
	Ctrl+NumPad -	Plummet all expanded nodes in the current view.
	Shift+Escape	Hide the tool window . To hide all the tool windows, press Ctrl+Shift+F12.

Terminal modified: 20 Apr 2022

Source: https://www.jetbrains.com/help/idea/database-tool-window.html

Posted by: adamsmeman1981.blogspot.com

Share this post