Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2014/12/24
Mohammad  Faisal
by Mohammad Faisal , Data Analyst , Websart.in Ltd Delhi

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);

Samiur Rahman
by Samiur Rahman , System Engineer/Project control coordinator , Chiyoda Corporation

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.

Emad Mohammed said abdalla
by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

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.

More Questions Like This