search
Login

Categories


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

3.8k questions

4k answers

117 comments

10.7k users

0 votes
14 views
asked Geek 15.3k points 16 41 63

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 Advisor 6.3k points 5 21 31

Related questions

0 votes
1 answer 21 views
21 views
asked smith Geek 15.3k points 16 41 63
0 votes
1 answer 9 views
9 views
asked rajesh Guru 39.1k points 10 21 33
0 votes
1 answer 7 views
7 views
asked john Guru 27.1k points 31 50 97
0 votes
1 answer 5.6K views
5.6K views
What is a view? How it is related to data independence?
asked denis Sr Member 2.7k points 14 29 61
0 votes
1 answer 36 views
...