What is View?

A View can be a thought of as a stored query accessible as a virtual table. It can be used for retrieving data as well as updating or deleting rows. Views in SQL SERVER provide a presist way to view data from one or more tables. They may also include aggregate fields(like COUNT, SUM). Views allow our users to query a single object which behaves like a table and contains the needed joins and fields we have specified. In this way, a simple query (SELECT * FROM MYVIEW) can produce more refiened result which can serve as a report and answer business question.

Rows updated or deleted in the view are updated or deleted in the table the VIEW was created with. It should also be noted that as Data in the original table changes, so does the data in the view - as view are the way to look at parts of the original table. The result of using view are not permanently stored in database. The data access through a view is actually constructed using a standred T-SQL SELECT command and can come from one to may different base tables or even other view.

Two main purpose of creating a view are
1. provide a scurity mechanism which restrict users to a creatain subset of data. means we ca create different schema on table and view and accroding to schema user can access view not a tbale if that user have not table schema if that user have only view schema
2. provide a mechnism for developers to cutomize how user can logically view data.

Create a View:

CREATE VIEW view_EMPLOYEE

SELECT * FROM EMPLOYEE

Retrieve data from view

SELECT * FROM view_EMPLOYEE

Hope It will be helpful.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vithal Wadje14y ago
view is the subsets of table by using which we Perform DML operation on table
view are created on table column...the syntax is below
```
CREATE VIEW view_name AS   SELECT columns   FROM table   WHERE predicates;
```
0
Sandeep Singh Shekhawat14y ago
A View can be a thought of as a stored query accessible as a virtual table. It can be used for retrieving data as well as updating or deleting rows. Views in SQL SERVER provide a presist way to view data from one or more tables. They may also include aggregate fields(like COUNT, SUM). Views allow our users to query a single object which behaves like a table and contains the needed joins and fields we have specified. In this way, a simple query (SELECT * FROM MYVIEW) can produce more refiened result which can serve as a report and answer business question.

Rows updated or deleted in the view are updated or deleted in the table the VIEW was created with. It should also be noted that as Data in the original table changes, so does the data in the view - as view are the way to look at parts of the original table. The result of using view are not permanently stored in database. The data access through a view is actually constructed using a standred T-SQL SELECT command and can come from one to may different base tables or even other view.

Two main purpose of creating a view are
1. provide a scurity mechanism which restrict users to a creatain subset of data. means we ca create different schema on table and view and accroding to schema user can access view not a tbale if that user have not table schema if that user have only view schema
2. provide a mechnism for developers to cutomize how user can logically view data.

Create a View:
CREATE VIEW view_EMPLOYEE

AS

SELECT * FROM EMPLOYEE

Retrieve data from view
SELECT * FROM view_EMPLOYEE
Hope It will be helpful.
0
Satyapriya Nayak14y ago
http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005

http://www.c-sharpcorner.com/UploadFile/6cde20/concept-of-view-in-sql-server/

http://www.quackit.com/sql_server/tutorial/sql_server_views.cfm

http://www.sql-server-performance.com/2004/views-in-sql-server/
0