# Database Changes tool window

> **TL;DR**
> `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 a 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 the 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](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_diff_via_database_changes.png)

| Icon | Action and shortcut | Description |
| --- | --- | --- |
|    ![the Submit button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.submitDB.svg)    |      Submit     `Ctrl+K` (Windows), `⌘ K` (macOS), `⌘ K` (IntelliJ IDEA Classic (macOS)), `⌘ K` (macOS System Shortcuts), `Ctrl+K` (XWin), `Ctrl+K` (GNOME), `Ctrl+K` (KDE), `Ctrl+K` (Emacs), `Ctrl+K` (Sublime Text), `Ctrl+K` (Sublime Text (macOS)), `Ctrl+K` (NetBeans), `Ctrl+Alt+K` (Visual Studio), `⌘ ⌥ ⇧ K` (Visual Studio (macOS)), `Ctrl+K` (Eclipse), `Ctrl+K` (Eclipse (macOS))     |  Submit local changes to the database server. For more information about submitting and reverting changes, refer to [Submit changes to a database](submitting-and-reverting-changes.html).  |
|  ![the Roll back icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.vcs.revert.svg)    |     Roll back     `Ctrl+Alt+Z` (Windows), `⌘ ⌥ Z` (macOS), `⌘ ⌥ Z` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ Z` (macOS System Shortcuts), `Ctrl+Alt+Z` (XWin), `Ctrl+Alt+Z` (GNOME), `Ctrl+Alt+Z` (KDE), `Ctrl+Alt+Z` (Emacs), `Ctrl+Alt+Z` (Sublime Text), `⌘ ⌥ Z` (Sublime Text (macOS)), `Ctrl+Alt+Z` (NetBeans), `Ctrl+Alt+Z` (Visual Studio), `⌘ ⌥ Z` (Visual Studio (macOS)), `Ctrl+Alt+Z` (Eclipse), `⌃ ⌥ ⇧ Z` (Eclipse (macOS))       |  (For the Manual transaction mode.) Roll back changes.   |
|  ![the Show Diff icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.vcs.diff.svg)  |     Show Diff       `Ctrl+D` (Windows), `⌘ D` (macOS), `⌘ D` (IntelliJ IDEA Classic (macOS)), `⌘ D` (macOS System Shortcuts), `Ctrl+D` (XWin), `Ctrl+D` (GNOME), `Ctrl+D` (KDE), `Ctrl+D` (Emacs), `Ctrl+D` (Sublime Text), `⌘ D` (Sublime Text (macOS)), `Ctrl+D` (NetBeans), `Ctrl+D` (Visual Studio), `⌘ D` (Visual Studio (macOS)), `Ctrl+D` (Eclipse), `⌘ D` (Eclipse (macOS))     |  Compare and see the difference between the code that you edited and the one from source code.  |
|  ![the Group by icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.show.svg)  |     Group by     |  Group objects according to their type. For example, routines, rules, or views.  |
|  ![the Expand All icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.expandAll.svg)  |     Expand All       `Ctrl+NumPad +` (Windows), `⌘ NumPad +` (macOS), `⌘ NumPad +` (IntelliJ IDEA Classic (macOS)), `⌘ NumPad +` (macOS System Shortcuts), `Ctrl+NumPad +` (XWin), `Ctrl+NumPad +` (GNOME), `Ctrl+NumPad +` (KDE), `Ctrl+NumPad +` (Emacs), `Ctrl+NumPad +` (Sublime Text), `⌘ NumPad +` (Sublime Text (macOS)), `Ctrl+NumPad +` (NetBeans), `Ctrl+NumPad +` (Visual Studio), `⌘ NumPad +` (Visual Studio (macOS)), `Ctrl+Shift+NumPad *` (Eclipse), `⌘ ⇧ NumPad *` (Eclipse (macOS))     | Expand all nodes in all trees. |
|  ![the Collapse All icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.collapseAll.svg)  |     Collapse All       `Ctrl+NumPad -` (Windows), `⌘ NumPad -` (macOS), `⌘ NumPad -` (IntelliJ IDEA Classic (macOS)), `⌘ NumPad -` (macOS System Shortcuts), `Ctrl+NumPad -` (XWin), `Ctrl+NumPad -` (GNOME), `Ctrl+NumPad -` (KDE), `Ctrl+NumPad -` (Emacs), `Ctrl+NumPad -` (Sublime Text), `⌘ NumPad -` (Sublime Text (macOS)), `Ctrl+NumPad -` (NetBeans), `Ctrl+NumPad -` (Visual Studio), `⌘ NumPad -` (Visual Studio (macOS)), `Ctrl+Shift+NumPad /` (Eclipse), `⌘ ⇧ NumPad /` (Eclipse (macOS))     | Collapse all nodes in all trees. |

## See also

### Getting Started

[Tool windows](tool-windows.html)

### Procedures

[Modify source code of database objects](modifying-source-code-of-database-objects.html)