The list of database objects depends on the selected database. Open a list of database objects that you can filter for the selected database. Open the list of query consoles for the selected data source.ĭata sources and their elements (tables and table columns) Update the source code of database objects by directly editing their DDL CREATE scripts and submitting your changes in the editor. This option works for tables, views, and materialized views. Open a table view of the object in the data editor. (The names of the data sources with active database connections are shown in bold.)ĭata sources with active connections and their elements Open the Data Sources and Drivers dialog to manage your data sources and their settings.Ĭlose the database connection for the selected data source or data sources. See also, Data sources and drivers dialog. Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). Specify the properties of the data source in the Data Sources and Drivers dialog that opens. If a DDL data source is selected, you can only choose to create another data source.Ĭreate a copy of the selected data source. The list of options depends on which element is currently selected.ĭata sources and their elements. The following video presents a short overview of the Database Explorer tool window.Ĭreate a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key. If the toolbar is hidden, the Refresh and Open Query Console commands can be access by means of the title bar icons ( and respectively). (If the toolbar is not currently shown, click on the title bar and select Show Toolbar.) Many of the commands have keyboard shortcuts. Most of the functions in this window are accessed by means of the toolbar icons or context menu commands. To learn more about working with database objects in DataGrip, refer to the Database objects section. Once DataGrip is connected to a database, Database Explorer will display the introspected and downloaded database objects. For information on how to connect to a database, refer to the Create connection section. If no data sources are currently defined, use the New command Alt+Insert to create a data source and connect to a database. The available data sources are shown as a tree of data sources, schemas, tables and columns. You can view and modify data structures in your databases, and perform other associated tasks. *.*.*.* link and select 5.1.40.Ĭlick the created MySQL data source entry.In the Database Explorer ( View | Tool Windows | Database Explorer), you can work with databases and DDL data sources. To learn how to work with database objects in DataGrip, see Database objects.Ĭannot connect to MySQL 5.* in the cloud with SSLĬlick the Driver link and select Go to Driver. To write and run queries, open the default query console by clicking the data source and pressing F4. (Optional) If you are connecting to a data source that contains a lot of databases and schemas, in the Schemas tab, select the schemas that you need to work with.įind your new data source in Database Explorer. To ensure that the connection to the data source is successful, click the Test Connection link. To delete a password, right-click the Password field and select Set Empty. Alternatively, paste the JDBC URL in the URL field. To download JDBC drivers for MySQL 5.1, click the Download link at the bottom of the dialog. In the Data Sources and Drivers dialog, click the Add icon ( ) and select MySQL.Ĭlick the Driver link and select MySQL for 5.1. 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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |