Creating a relational view

You can create one or more relational views of your database.

To create a relational view:

  1. In the Data Definition view, expand your project, database, and the schema folder for the schema in which you want to define a relational view.

  2. Right-click the Views folder, click New > View Definition to open the New View window.

  3. Type the name of the relational view. The name that you specify will be the name of the view object and cannot be changed unless you change it manually in the DDL file that you generate. This name must be unique and it cannot contain spaces or any of the following characters: ? < > | : * # /.

  4. Select the type of SQL statement that you want to use to create the relational view definition. Depending on your database vendor, the statement can be a SELECT, FULLSELECT, or WITH query.

  5. Click OK.

A relational view appears under the Views folder and opens in the SQL Builder. In the SQL Builder, you can view the name of the relational view and define aliases for the view columns. The view columns are derived from the view statement. You can also build the SQL statement for the view by typing it in to the SQL Source pane.

 

Parent topic

Accessing and updating data

 

Related concepts

Relational views