what is view in sql server??

Question

Sukesh Marla · Answer

iew is nothing but saved SQL Statements or can be defined as an object that derives its data from one or more tables or in simple words we can say it as virtual table. (Views don't occupy storage space,Exception is indexed view..discussed in later posts). Why to use Views: Query simplicity :-We may create a view using a complex query which can be easily queried later. security:- Views ensure the security of data by restricting access only to specific rows and columns. http://www.sukesh-marla.com/2010/12/sql-views.html Refer this link to read more. Hope It Helped. Please Mark answer as Accepted Answer .

Akkiraju Ivaturi · Answer

Following link from MSDN gives more details about views: http://msdn.microsoft.com/en-us/library/ms187956.aspx A view is a collection of data from many tables which can be consumed by a program without worrying about what table to use and types of joins to be used to get the same data. Also, views provide security to the database objects by giving only execute permissions on the views and no permissions to read or write the data objects. Also, if tables are changed, still your program can work on the same view even though internally the queries are changed in the view.