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

3,749 questions

4,049 answers

114 comments

10,705 users

What is View?

0 votes
12 views
asked 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 by kelly johnes Advisor (6,330 points)

Related questions

0 votes
1 answer 18 views
18 views asked by smith Geek (15,340 points)
0 votes
1 answer 7 views
7 views asked by rajesh Guru (39,140 points)
0 votes
1 answer 5 views
5 views asked by john Guru (27,140 points)
0 votes
1 answer 5,631 views
5,631 views asked by denis Sr Member (2,740 points)
...