Adding an Embedded SQL View

If you want to add custom business rules in your model without creating a new view in your database schema, you can create an inline embedded SQL view. This allows you to create a virtual “table” by embedding a SQL directly into the physical view.

Note: An embedded view may result in a different execution plan than a database view. You should test both options against your database.

To create an embedded view, follow the steps below.

1. Click the 'New View' button.

2. Enter the view name in the 'Name' field, and type in the SQL query string into the 'SQL' field.

 

3. Press 'OK'. This adds the embedded view as a new table in the diagram panel.

 

4. Join this table to other tables/views in the physical view as required.

See Also

Defining Expression Attributes, for information on creating formula columns.

<< Adding Database Tables to the Physical View © 1996-2013 InetSoft Technology Corporation (v11.4) Defining Join Relationships >>