What is a SQL view? Briefly explain the use of views.

view is nothing but An image table and virtual table,which create for a base table.these are two type of Views available in SQL server.

Simple view

Complex View

simple View----creating View by taking only one single base table

complex view-----creating View by taking only one multiple base table

SIMPLE VIEW EXP-----

Create view V1 AS select * from Emp

insert into V1 values(10,'Faisal',105);

View in general describe as a window in a Room, same way view is a window in a table. In other words dbo can allow a user to show or hide the information in table by creating and allowing permision on the view instead of table.

A SQL view is a virtual table built from other tables or views. Views are used to (1) hide columns or rows, (2) show the results of computed columns, (3) hide complicated SQL syntax, (4) layer built-in functions, (5) provide a level of indirection between application programs and tables, (6) assign different sets of processing permissions to tables, and (7) to assign different sets of triggers to the same table.