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.
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|
Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles