Views are used to select  particular columns from a table 
which is residing in a different DB. Once views are 
crerated we can access the view to get the specified column 
details from the table which is present in a different DB

View is used to fetches the data from existing table and it 
doesn't occupy any space in memory.

view eassy to use , views used to work with part of the 
tables.
** provides security for the data.

Some times we need to use the same query repeatedly for a 
large number of times.So instead of writing the same query 
all the times we use views. Means we store the query with a 
name that name is called as a view.

in sql was operation doing DML,DCl querey.

1. View is logical representation of the table.
2. View is derived from the table.
3. view don't occupy any memory space.

purpose.
1. Security
2. Simplicity of the query.

Another Important Point : view is updatble.

By
Kumar.T

A view is a virtual table. A view serves as a security 
mechanism. If we have several tables in a database and we 
want to view only specific columns from specific tables we 
can go for views. Using view we can avoid the complex 
queries.

Views are dynamic table that is it created at run time and 
not stored on server database.
by using view we can solve typical query.

Not all the views are updatable. updatable viwes are
available from SQL Sever 2000 version. 

Pls remember all the views are not up datable again.