![]() ![]() If there are certain objects you don’t want to see in the database tree, you can hide them in the data source properties ( Properties | Schemas).įor instance, you can hide all tables with a specific prefix. You can manage this grouping in the datasource settings. In DataGrip these secondary objects are hidden under two nodes: Server Objects and Database Objects. People are constantly working with tables, views, and routines, but users, roles, tablespaces, foreign data wrappers, and many other object types are not used as frequently. You can also use Ctrl+C, Ctrl+V, and Ctrl+X ( ⌘+C, ⌘+V, and ⌘+X for MacOS) to copy, paste, and cut your data sources between folders. The same works when placing the data source into an existing group – just drag-and-drop it there. ![]() To create a new group, just drag one data source onto the other. ![]() Press F6 or choose Move to group in the context menu.ĭrag-and-drop also works for creating groups in the database explorer. ![]() When you’re working with a large number of data sources, it can be convenient to group them, just as you would do with folders on your computer. For instance, ‘ fa‘ is enough to find ‘ film_actor‘. Note that speed search works only for expanded nodes. You can use the arrow keys to navigate through the matches. The matching part of the string is highlighted. Just start typing! As you type, a text field appears over the database explorer window, the entered characters are displayed, and the selection moves to the first item that matches your search query. The only thing you will need to specify again is the password, because that isn’t copied with the data source. You can then just paste this XML snippet as a new data source in a database tool window inside the same IDE or in another JetBrains IDE ( Ctrl+V for Windows/Linux, ⌘+V for MacOS). Put the cursor on the data source and press Ctrl+C/⌘+C, and an XML snippet will be created on your clipboard. Just use Ctrl+C, Ctrl+V, and Ctrl+X ( ⌘+C, ⌘+V, and ⌘+X for MacOS) to copy, paste, and cut your data sources, respectively. Duplicating or creating a similar data source.Distributing data source settings among team members.Easy copy-pasting of data sourcesĬopy-pasting data sources can be useful in the following situations: Here are the advantages of the DataGrip database explorer that our users value most. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases and DDL data sources. You can view the structure of your databases and perform other tasks in the database explorer. Right-click a diagram and select Export Diagram | Export to Image.JetBrains DataGrip is a powerful tool for working with databases. To open the saved diagram, drag the UML file to the editor. Right-click a diagram and navigate to Export Diagram | Export to File | IDEA. This UML format is an internal format supported only by IntelliJ IDEA. Save diagrams Save diagrams in the UML format Refresh the diagram to apply the color by clicking the Refresh button (). In the Database tool window ( View | Tool Windows | Database), right-click an object and select Tools | Set Color…. For more information about generating a diagram, see Generate a diagram for a database object. Use the mouse wheel to extra zoom the diagram area within magnifier tool. To use the magnifier tool, keep the Alt key pressed, and hover over the desired areas of the diagram. You can also use Shift + mouse wheel for zooming. To pan and zoom the diagram, use your touchpad, scroll bars or the mouse wheel for vertical scrolling and Shift + mouse wheel for horizontal scrolling. In the Database tool window ( View | Tool Windows | Database), right-click a database object and select Diagrams | Show Diagram. For more information about creating an execution plan, refer to Visualize a query plan. An execution plan is a set of steps that were used to access data in a database. If you want to share the created diagram, consider using PNG.Īlso, you can build execution plans. The UML format is an internal format developed specifically for IntelliJ IDEA. You can save the generated diagrams in two formats: UML and PNG. To create relations between database objects, consider using primary and foreign keys. You can generate a diagram for a data source, a schema, or a table. Database diagrams graphically show the structure of the database and relations between database objects. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |