Relational views

A relational view is a named result set of an SQL query.

Views display different perspectives of the same database. Views are stored in the databases and the view query defines which database tables, columns, and rows are viewed. The access to the data is simplified because the structure of the data from one or more databases tables is presented in a single table that eliminates unnecessary data. The data is always presented consistently in a relational view even if the actual database tables are split, restructured, or renamed.

You can use the View Builder to build the query for your relational view and provide aliases for the view columns. You can provide aliases for the view columns so that the names are different than the query result set column names.

The View Builder has two pages: the View Details page and the View Query page. The View Details page shows the name of the view and a grid of the columns of the view. The grid is empty until the view query is created. When there are columns in the view, you can provide aliases for each of the columns. If you do not specify an alias, the column name from the query result set is used.

 

Parent topic

Accessing and updating data

 

Related tasks

Creating a relational view