C Books Guide and List
C++ Books Guide and List
Best Java Books

3,749 questions

4,049 answers


10,705 users

What is View?

0 votes
asked Mar 8, 2014 by smith Geek (15,340 points)

1 Answer

0 votes
A simple view 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 with. 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. The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.
answered Mar 8, 2014 by kelly johnes Advisor (6,330 points)

Related questions

0 votes
1 answer 17 views
17 views asked Dec 31, 2013 by smith Geek (15,340 points)
0 votes
1 answer 6 views
6 views asked Dec 24, 2013 by rajesh Guru (39,140 points)
0 votes
1 answer 5 views
5 views asked Dec 23, 2013 by john Guru (27,140 points)
0 votes
1 answer 5,629 views
5,629 views asked Aug 21, 2011 by denis Sr Member (2,740 points)
0 votes
1 answer 26 views