Register now or log in to join your professional community.
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.