SQL Create View

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_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

SQL CREATE VIEW Syntax

  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

SQL CREATE VIEW Query

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

Result

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