-
-
Table dropped after creating view Issue
A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?
-
What is a view?
A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logical representation of one or more database tables. As we have seen above views have no data for themselves...
-
-
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.
-
If a View on a single base table is manipulated will the changes be reflected on the base table ?
If changes are made to the tables which are base tables of a view will the changes be reference on the view.