RE: If a View on a single base table is manipulat...
if view on based on a single table then u can execute any DML directly on it and can see the changes in the base table
and ifview is based on join of 2 tables then only one base table can be modified at one time so in order to make changes in both the tables use insted of triggers
RE: If a View on a single base table is manipulat...
Hi
1) View is like getting information from many tables and displaying the result to the user. 2) If the view is modified it does not effect the base table. 3) If the base tables are modified then it will effect the views it depends on what changes have you performed in the base tabe like dropping columns etc..