What is a view?

 Posted by Karthikanbarasan on 1/8/2011 | Category: Sql Server Interview questions | Views: 3194 | Points: 40

? It can be thought of as a subset of a table.
? It can be used for retrieving data, as well as updating or deleting rows.
? Rows updated or deleted in the view are updated or deleted in the table the view was created.
? It should also be noted that as data in the original table changes, so does data in the view, as views are the way to look at part of the original table.
? The results of using a view are not permanently stored in the database.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response