Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › View Properties › Define a View in SQL Azure › Specify Properties for the WHERE Clause for a SQL Azure View

Specify Properties for the WHERE Clause for a SQL Azure View

Use the Where tab in the SQL Azure View Editor to specify search conditions for queries against a view. The information you enter in the fields in this tab become the SQL code that is generated.

To specify the properties for the WHERE clause for a SQL Azure view

1. Click Views on the Model menu.

   The SQL Azure View Editor opens.

2. Select the view in the Navigation Grid for which you want to specify WHERE clause properties.
3. Click the Where tab and enter the values for the WHERE clause for the selected view using the following fields:

   Where

   Defines the search condition that must be satisfied by the results of the query. The text you enter becomes the WHERE clause in the SQL code that is generated. The WHERE clause excludes rows that do not meet the search condition.

   Group By

   Defines the criteria to use to group rows returned by the query. The text you enter becomes the GROUP BY clause in the SQL code that is generated. The GROUP BY clause places the selected rows into one group for each unique value.

   Having

   Defines 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.

   Restriction

   Applies the With Check Option restriction to the WHERE clause.

4. Click Close.

   The WHERE clause properties are specified for the selected view and the SQL Azure View Editor closes.