Watch Our YouTube Channel
It is currently Fri May 26, 2017 2:49 pm
 

All times are UTC



Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Sat Feb 04, 2017 7:57 am 
Offline

Joined: Fri Nov 13, 2015 3:56 am
Posts: 402
A view is actually a composition of a table in the form of a predefined SQL query.

A view can contain all rows of a table or select rows from a table.

SQL creates the illusion of the view by giving the view a name like a table name and storing the definition of the view in the database.

When the view is queried, SQL Server automatically determines which tables are affected by the query and references only those tables.

Views are used for security purpose in databases,views restricts the user from viewing certain column and rows means by using view we can apply the restriction on accessing the particular rows and columns for specific user.

Performance - since the joins already made and the tables are virtual, it's quicker to run a query on that dataset

It will decrease the complexity of your query.

_________________
Learn Web Development | Latest Technology News |Motivational Quotes


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron