Creating Models › Creating a Physical Model › Views › View Editor › Change the SQL Code for a View

Change the SQL Code for a View

You can use the SQL tab in the View Editor to view and change the SQL code that is maintained for a view.

To change the SQL code for a view

1. Right-click the view for which you want to change the SQL code and click View Properties.

   The View Editor opens.

2. Click the SQL tab and click the button.

   The SQL dialog opens.

   Where

   Lets you enter the search condition that must be satisfied by the results of the view query. The text you enter becomes the WHERE clause in the SQL code that is generated for the selected view.

   Group By

   Lets you enter the criteria that you want to use to group rows returned by the view query. The text you enter becomes the GROUP BY clause in the SQL code that is generated for the selected view.

   Having

   Lets you enter the search condition that is applied to each row group, and filter out rows that do not meet the specified search condition. The text you enter becomes the HAVING clause in the SQL code that is generated for the selected view.

   Note: This option is only available if your target DBMS supports the HAVING clause.

3. Change the SQL code as needed. Work with the options on the toolbar to save, print, find and replace, and cut, copy, or paste text.
4. Click Close.

   SQL code is changed for the selected view and the View Editor closes.