You can use the Explain Plan action to see the execution plan of your query, which shows how the database will process your query and what operations it will perform. You can use the Type drop-down menu to show only tables, views, materialized views, or synonyms.ĭataGrip gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. You can also drag-and-drop columns to insert their names or values, depending on the context.Īnother improvement is the ability to filter tables by their type in the Database tool window. In DataGrip 2018.1.2, you can now drag-and-drop tables from the Database tool window into the editor to insert their names into your queries. You can also use the Database tool window to browse and manage your data sources and schemas. Then, you can use the Ctrl+Alt+Enter shortcut to execute queries in a transactional mode, or use the corresponding button on the toolbar.ĭataGrip lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. To enable this mode, go to File | Settings | Database | General and check the Use transactional mode option. This is useful for testing or debugging purposes, as you can easily revert any unwanted modifications. This means that you can start a transaction, execute multiple queries, and then commit or rollback the changes as a whole. One of the new features in DataGrip 2018.1.2 is the ability to run queries in a transactional mode. You can also use various shortcuts and actions to speed up your coding process. In this article, we will explore some of the features and improvements that were introduced in DataGrip 2018.1.2, the latest version of the IDE as of April 2023.ĭataGrip's query console allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Whether you need to connect to multiple data sources, write complex queries, refactor your code, or manage your schemas, DataGrip has you covered. JetBrains DataGrip is a cross-platform IDE that provides a comprehensive set of tools for working with databases and SQL. JetBrains DataGrip 2018.1.2: A Powerful IDE for Databases and SQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |