This tab allows to compare definition of particular view or materialized view:
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:
Vertical toolbar between two panels contains additional tab-specific actions:
When bottom text preview is active (for view definition, index or trigger), it contains two more actions:
Free version limitations:
Last updated: 2024-07-17