IntelliJ IDEA 2016.3 Help

Differences viewer for table structures

/help/img/idea/2016.3/dbe_compareTableStructures.png

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

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