What is a view?
Interview question and answer by: Karthikanbarasan
| Posted on: 1/8/2011 | Category: SQL Server Interview questions
| Views: 1302 | | 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.
| Alert Moderator
Found interesting? Add this to: