Table Structure Diff Tab

Opened from: Object list and Data 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 MS Access, table structure diff tab annotated

Tab is divided into 6 major collapsible sections (Linked table, Fields, Indexes, Data macros, Parent relations and Сhild relations) and bottom panel for selected item details. Here is explanation of changes highlight annotation on the above screenshot:

1 Changed item (`Invoice Date` which has changed Format)
2 New item (`Comment` field on the right, Order ID index on the left)
3 Unchanged field with changed display order (`Amount Due`)
4 Changed field with changed display order (`Due Date` has changed Format)

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

Field properties are shown and field merge/delete actions are available only if the 'Load field properties' option is enabled in Settings dialog.

PrimaryKey value in the Fields grid just indicates that this field participates in the Primary index. It can't be merged with a field, only by merging that primary index.

Free version limitations:

The whole tab is not available

Last updated: 2024-10-21