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

Syntax:

db2 create view <view_name> (<col_name>,
<col_name1...) as select <cols>..
from <table_name>  

Example:

CREATE VIEW DB2ADMIN.FRESHERS_VIEW AS db2 create view freshers_view(ID, Name, Age, Address, Salary)
as select ID, Name, Age, Adress from
employee.freshers

Advantages of VIEW

It makes data easier to use because it represents data from more than one tables as a single table.
It can increase security because it restrict the access to the base tables and providing the access to the view can increase security to base table data.
It can increase controlled access over the database.
It can able to hide the complex queries and makes the end user life easy by representing the data in single table from more than one table.
Views can have the derived columns, apart from the retrieved columns.

Next TopicCreate Index

← prev next →