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 Ctrl+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 Ctrl+F6. To enable descriptions for databases and tables, navigate to View | Appearance and select Descriptions in Tree Views. 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 Color Settings…. The text data viewer 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 ( 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 Ctrl+Z.
#Mysql workbench export connections password#
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 Ctrl+C, Ctrl+V, and Ctrl+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 Show Options menu 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 define the following data sources:ĭatabase data source: operational databases that contain data (see Database connection).ĭata Definition Language (DDL) files: SQL files that contain data definition language statements.Ĭonfigure display options for data sources Data source is a location of data for your application.
0 kommentar(er)
