Database Views

A view is a logical representation of another table or combination of tables. A view does not contain any data. It gets its data from the tables on which it is based. These tables are called base tables. Base tables can be actual tables or they can be views themselves. Any operations performed in a view actually affect the view's base table. You can use views in much the same way as tables. You can query, update, insert, and delete from views just as you can with standard tables.

Views can provide a different representation (such as subsets or supersets) of data found in other tables and views. The performance of views is very powerful because they allow you to tailor the presentation of data to different types of users.

To create database views, you must select a Database Table Group , a Database Schema , and one of the following "View Types".

• FLD - Standard Field Definition
• SQL - SELECT SQL Defined

Then, you can write the coding under the "VIEW FROM - WHERE Clause" tab.

Create or Delete a View

All database views will be listed in the "Database Views" screen.

You can cancel (override) or create views using the corresponding "Drop" and "Create" buttons.