Table Structure Diff Tab

Opened from: Object list, Data diff and Text diff tabs
Applicable tab-specific toolbar actions:
- Export to Xlsx or Json
- Jump to the last, next, previous, first change
- Select all, none, invert selection on the left, all, none, invert selection on the right side
- Merge left selected items to the right side, right selected items to the left side
- Delete selected items on the right side, selected items on the right side
Applicable object types: Tables

This tab allows to compare definition of particular table:

for MySQL, table structure diff tab annotated

Tab is divided into 4 major collapsible sections (Columns, Constraints, Indexes and Triggers) and bottom panel for selected item details. Here is explanation of changes highlight annotation on the above screenshot:

1 Changed item (`phone` which has changed Nullability)
2 New item (`address2`)
3 Unchanged column with changed column order (`district`)
4 Changed column with changed column order (`location` has changed nullability)

Vertical toolbar between two panels contains additional tab-specific actions:

Open data diff for the current table
Open data diff for the current table filtered only to new and changed records
opens query result diff with select top 1000 records statement for this table
'Open table definition as text' opens text diff tab with table script generated by application
'Open SHOW CREATE TABLE result' opens text diff tab with table script provided by database server with SHOW CREATE TABLE command

Please note that merge/delete action may fail because of limitations caused by other objects such as foreign keys, existing data and so on. Please check the merge execution result for details.

Column Extra for columns can have one of two things: AUTO_INCREMENT or ON UPDATE rule. If the column is AUTO_INCREMENT and selected to be merged, then the generated merge statement has PRIMARY KEY included even if it is not selected in Constraints, because auto-increment can not be specified without a key.

Free version limitations:

The whole tab is not available

Last updated: 2024-10-21