DataGrip 2017.2 Help

Differences viewer for tables

The primary purpose of the differences viewer for tables is to show the differences and similarities of data.

Detect column insertion

When the tables have different number of columns, "extra columns" in the table with more columns are ignored. If the Detect column insertion option is on, the most different columns are ignored. On the following picture, the first column in the second table is the most different and so it is ignored. As a result, the second row is shown as containing the same data.

/help/img/idea/2017.2/dbe_compareTableData.png

If the option is off, ignored are the last of the columns. On the following picture, the last column in the second table is ignored. So all the rows are shown as containing different data.

/help/img/idea/2017.2/dbe_compareTableData_a.png

Tolerance

Tolerance is how many columns may be different. With zero tolerance on the following picture, the first row is shown as containing different data.

/help/img/idea/2017.2/dbe_compareTableData.png

With the tolerance of one on the following picture, the first row is shown as containing about the same data.

/help/img/idea/2017.2/dbe_compareTableData_b.png
Last modified: 9 October 2017

See Also

Procedures: