IntelliJ IDEA
 
Get IntelliJ IDEA
You are viewing the documentation for an earlier version of IntelliJ IDEA.

Differences viewer for database objects

Last modified: 07 May 2021

In the Database tool window, select two database objects and press Ctrl+D.

Compare Content is available in the context menu for tables, views, and materialized views.

To increase the number of compared rows, configure the Limit page size to parameter.

The differences viewer shows you differences and similarities between two database objects. In IntelliJ IDEA, you can compare two database objects of the same type. For example, you can compare two schemas, two tables, or two routines. IntelliJ IDEA shows you the differences in the structures of these two objects.

Compare table structures

The Compare Content action compares the output of tables, views, and materialized views. To find this action, select two objects in the Database tool window (View | Tool Windows | Database) and right-click the selection. Also, you can double-click these objects and then compare them from the editor.

You can compare the contents of two objects that belong to different types. For example, the output of a table and a materialized view.

Table contents