Create View

SQL Views

A VIEW is a virtual table, through which a selective portion of the data from one
 or more tables can be seen. Views do not contain data of their own. They are
used to restrict access to the database or to hide data complexity. A view is stored
as a SELECT statement in the database. DML operations on a view like INSERT, UPDATE,
DELETE affects the data in the original table upon which the view is based.
view_name is the name of the VIEW.

 The SELECT statement is used to define the columns and rows
that you want to display in the view.

For Example: to create a view on the product table the sql query would be like

CREATE VIEW Emp_view
AS
SELECT Employee_id, First_name
FROM Employees;