For the view selected in the Views tab, this tab provides the SQL that generates the view.
This tab also provides a right-click shortcut menu with one command: Apply Changes. After modifying the SQL, this command applies the changes to the database.
NOTE: All columns in the SELECT statement must have column names/aliases because the system automatically builds the view-definition portion of the view statement from the SELECT statement in the Source tab. Furthermore, for existing views, the aliases must match the original view column names. If any column names/aliases are missing, then an error will occur when you select the Apply Changes command.

  • No labels