Views in SQL
A View is a virtual or imaginary table based on the outcome of a SELECT
statement. A view include rows and columns as real table. A view include a
fields is similar to one or more real tables in database. A view of a table does
not store a data.
Understand with Example
The Tutorial illustrate an example from 'View in SQL'. To understand this
example we create a table 'customer'. The create table is used to create
a table customer with required field attribute and data type respectively.
Create Table 'customer':
create table customer(First_Name varchar(15),Last_Name varchar(15),Address varchar(15),City varchar(15),Country varchar(15));
|
Insert values into Table 'customer':
The insert into add the records or rows to the table 'customer'.
To see the detail of table 'customer':
The Select keywords returns you the set of records from table
'customer'.
Create View 'viewCustomer':
Now we apply view on Table 'customer'. The create VIEW is used to
create a view 'viewCustomer' that contain the first_name,last_name and country
field name from table 'customer',
create VIEW viewCustomer as SELECT First_Name,Last_Name,Country
FROM Customer;
|
View Details :
The select return the set of records or rows from 'viewCustomer'.
| select * from viewCustomer; |
Output is displayed as :
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
