Share on Google+Share on Google+

SQL Create View

sql create view

SQL Create View


A View is a imaginary and virtual table in SQL. In SQL, a view is defined  as a virtual table outcome as a result of an SQL statement. A view include rows and columns is simply like a real table. The column in a view is the result-set of one or more real tables in the database. The views include a SQL functions like WHERE Clause and JOIN statements ,which is used to view the present data as it seems to be outcome of single table.

  Understand with Example 

 The Tutorial illustrates an example from SQL Create View. In this Tutorial, we create a table 'Stu_Table with respective field attribute and data  type respectively.

  create table: The create table keyword is used to create a table Stu_Table.

Create Table Stu_Table

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class  varchar(10))

  Once your table Stu_Table is created, The insert into statement of SQL is used to insert the records or rows into the table name Stu_Table.

   insert into :The insert into is used to add the records or rows into your created table 'Stu_Table'.

Insert data into Stu_Table

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);
insert into Stu_Table values(6,'Tanuj',10);

 The Select Statement return you the records present in the table stu_Table.


Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10
6 Tanuj 10


  A view shows updated records. The database recreate the data using view's SQL statement. The user write a queries view..

CREATE VIEW View_Name( Column_Name )
AS SELECT  Column_Name 
FROM Table_Name


The view "Stu_View" include the list of  all the column from table "Stu_Table",which  you want to show in view table. The Syntax used to create view table in SQL is given as:

CREATE VIEW Stu_View( Stu_id, Stu_Name, Stu_Class)
AS SELECT  Stu_id, Stu_name, Stu_class 
FROM Stu_Table

Display records form View

Once the view is created ,You can use select  query to retrieve the records from 'Stu_View' table.

Select * from Stu_View


Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10
6 Tanuj 10



Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: SQL Create View  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
May 24, 2011
create view

Create a view named member_income that lists the member number, first and last name, and the total income generated by each member. Please include the rental fee as well as any additional fine the member may have paid the company.