In the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties button ( ). You can copy a data source if you need to use the same data source in another project, but have different requirements to it, such as its accessibility level (project or global), the user, database connection and schema settings, and so on. To share a data source between different projects inside your IDE, you need to move the data source to the global level. By default, a data source is available at the project level. At the global level, a data source is available for other projects. The project level means that you can access a data source only from the project where this data source was created initially. In the Database Explorer ( View | Tool Windows | Database Explorer), click a node that groups database objects, and press F4.ĭata sources in DataGrip are available at two levels: project and global. View contents of a node in Database Explorer Right-click a tab of a query console and select Shorten Tab Titles. A data source name in the tab title is shortened to 36 characters. To add comments for a database, open database settings Control+Alt+S and add a database description in the Comment text field.īy default, the Shorten Tab Titles option is enabled. In the Comment text field, add a table description. To add comments for tables, select a table and press Control+F6. To enable comments for databases and tables, click the Options icon ( ) on the title bar of the Database Explorer and select Show Comments instead of Details. Show comments for data sources and database objects To select the necessary objects, use the Filter icon on the toolbar. To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox. In the Database Color Settings dialog, select the dialog and coloring options. To set a color, right-click a data source and select Tools | Set Color. The code editor and data editor tabs can use the color of the data source. Select the data source for which you want to assign a color.Ĭlick the circle in the Name field to select a color.įor more examples about using colors with data sources, see the following video at .Īssign a color to query consoles and grids In the Database Explorer Command 1 ( View | Tool Windows | Database Explorer), click the Data Source Properties icon ( ). You can open data source properties by using one of the following options: To have better differentiation between production and test databases, you can assign a color to a data source. The cut operation can be undone by using Control+Z. But the password is required in all the other cases. If you cut and paste a data source inside one project, it will be just moved, no password is required. To remove a data source from the folder, select Root folder.Īlso, you can use Control+C, Control+V, and Control+X to copy, paste, and cut your data sources between folders. To create a new folder, select New Folder. If you have folders with grouped data sources, you will see the Move to Folder dialog. For example, the QA/Quick name will create the Quick folder inside the QA folder. You can use a forward slash ( /) to define nesting. If you do not have any folders, you will see the New Folder dialog. Alternatively, right-click a data source and select Move to Folder. In the Database Explorer ( View | Tool Windows | Database Explorer), select the necessary data source and press F6. In the Database Explorer ( View | Tool Windows | Database Explorer), the view of the data source changes instantly.įor more information about the view options, see View options. To group, enable, or sort data sources, click the Options icon ( ) on the title bar of the Database Explorer and select the necessary options. Customize the view of objects in the Database Explorer You can group, assign a color, and filter objects in the Database Explorer ( View | Tool Windows | Database Explorer). In DataGrip, you can create the following data sources:ĭatabase data source: operational databases that contain data (see Create connection).ĭata Definition Language (DDL) data source: SQL files that contain data definition language statements (see DDL data sources).Ĭonfigure display options for data sources You can see the list of created data sources in the Database Explorer ( View | Tool Windows | Database Explorer). To manage these settings, in the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties button ( ). In a data source, you can also select databases and schemas for introspection and display in Database Explorer, change driver, configure SSH and SSL connection, and so on. Data source stores a list of connection details that are used to establish connection to a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |