View Definition Diff Tab

Opened from: Object list tab
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: Views and Materialized views

This tab allows to compare definition of particular view or materialized view:

for PostgreSQL, view definition diff tab

Tab is divided into 3 major collapsible sections (View definition, Indexes for materialized views or Triggers for views, and Columns) and bottom grid/text preview of the selected item. Column list is marked as DIFF ONLY because this list is driven by the query definition SELECT statement. Column changes are highlighted but they do not affect the result of checking whether the view is changed or not. 'SELECT * ..' kind of view can be counted as non-changed if the view definition text is the same, but the column list can be different because of changes in the underlying tables. Columns can be shown in the one of two modes:

Natural order - column are shown in the order they are returned by the view
Sorted by name

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

'Open view definition as text' opens text diff tab with a view script
Open data diff for the current view
Open data diff for the current view filtered only to new and changed records
opens query result diff with select top 1000 records statement for this view

When bottom text preview is active (for view definition, index or trigger), it contains two more actions:

Show text preview line totals
Show text preview selected line

Free version limitations:

The whole tab is not available

Last updated: 2024-10-21