IntelliJ IDEA 2016.2 Help

Differences viewer for table structures

dbe_compareTableStructures

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

IconDescription
arrow_right The column, constraint or index exists only in the left-hand table.
not_equal The items exist in both tables but their definitions are different. You can study the differences in the lower part of the view.
equal The items are identical.
arrow_left 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 arrow_right, not_equal and arrow_left. 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.

See Also

Last modified: 23 November 2016