Views in SQL

A View is a virtual or imaginary table based on the outcome of a SELECT statement.

Views in SQL

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'.

select * from  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 :