IntelliJ IDEA
 
2024.1
Shortcuts: Windows
Get IntelliJ IDEA
You are viewing the documentation for an earlier version of IntelliJ IDEA.
Upcoming webinar
Gatherers: The API Your Stream Was Missing
March 13, 2025 at 03:00 PM
  1. Database Tools and SQL
  2. Database objects
  3. Modify source code
  4. Database Changes tool window

Database Changes tool window

Last modified: 31 May 2024

View | Tool Windows | Database Changes

IntelliJ IDEA tracks changes you make to the source code of any database object, provided its source code is stored in database. For example, such objects are views, stored procedures, triggers, and so on. Tables do not have stored source code.

If there are various changes made to source code of many objects, you can see all of them in the Database Changes tool window.

note

The Database Changes tool window becomes available only after you change the source code of a database object.

the Database Changes tool window

Icon

Action and shortcut

Description

the Submit button

Submit

Ctrl0K

Submit local changes to the database server. For more information about submitting and reverting changes, refer to Submit changes to a database.

the Roll back icon

Roll back

CtrlAlt0Z

(For the Manual transaction mode.) Roll back changes.

the Show Diff icon

Show Diff

Ctrl0D

Compare and see the difference between the code that you edited and the one from source code.

the Group by icon

Group by

Group objects according to their type. For example, routines, rules, or views.

the Expand All icon

Expand All

CtrlNumPad +

Expand all nodes in all trees.

the Collapse All icon

Collapse All

CtrlNumPad -

Collapse all nodes in all trees.

See also

Procedures

Getting Started