KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Oracle logo for Oracle
 
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

View definition diff tab

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

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

for Oracle, view definition diff tab

Tab is divided into 3 or 4 major collapsible sections (View definition, Indexes for materialized views, Triggers, 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