SQL Views explanation

Posted by Prabhukiran345 under Sql Server category on | Points: 40 | Views : 1020
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.
The Syntax to create a sql view is
CREATE VIEW view_name 
SELECT column_list
FROM table_name [WHERE condition];

Comments or Responses

Login to post response