A view is a logical representation of a table, more than one table, or even other views. Users can use views to access data from one or more tables in an alternate format and sequence than what is represented in the table. A view cannot refer to more than 32 real tables including tables referred to in underlying views. Views are identical to the system logical files.
When a view is used for more than one table or view, the tables or view are said to be joined.
You can perform the following tasks with views:
For more information about views, see Views in the SQL Programming topic in the
Information Center .