DB2 RazorSQL View
A view is used to define an alternative way of representing the data stored in a table. A view is not a real table and doesn?t have any permanent storage. It facilitates you to look at the data in one or more tables. It is a named specification of a result table.
A VIEW can derived from one or more tables. You can use upto 15 tables to create a VIEW.
A VIEW can contain all the columns or a certain columns from the table.
Create a View
Advantages of VIEW