DataGrip 2020.1 Help

Differences viewer for table structures

Compare table structures

Comparison statuses are shown in the column marked with an asterisk (*).

To see how you can compare two tables or result sets, go to Compare two table structures and Compare two result sets.

IconDescription
The column, constraint or index exists only in the left-hand table The column, constraint, or index exists only in the left-hand table.
The items exist in both tables but their definitions are different The items exist in both tables but their definitions are different. You can study the differences in the lower part of the view.
The items are identical The items are identical.
The item exists only in the right-hand table The item exists only in the right-hand table.

Generating ALTER TABLE statements

You can generate a set of ALTER TABLE statements for making data definitions in the left-hand and the right-hand parts identical. Use one of the following buttons in the upper part of the view:

  • Migrate Left: the statements for the left-hand table or tables are generated.

  • Migrate Right: this buttons does the same but for the right-hand table or tables.

The ALTER TABLE statements are generated for the items marked the Arrow right icon, the Not Equal icon and the Arrow Left icon. If you don't want to generate the statements for some of those items, right click the * cell and select Set Do Nothing for all such items.

Last modified: 08 May 2020