suresh

• Aug 24th, 2005

 

If we do some modificatios on base table, those changes will be displayed in existing view or not?

pooja

• Nov 27th, 2005

 

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

Ravindra wadalkar

• Jan 2nd, 2006

 

Yes,it will be reflected

vijay saxena

• Oct 24th, 2006

 

if the reference to the base table is made then any changes will also affected in base table respect to view table.

rayadurgamsudha

 Profile Answers by rayadurgamsudha 

• Mar 11th, 2007

 

yes, the changes can be viewed in the base table if and only if the view is on a single base table.

Bharath kumar

• Mar 25th, 2007

 

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..

Animesh Mondal

• May 11th, 2015

 

The view must have the Primary Key and NOT NULL columns of the base table for any insert to happen on a view

Andy

• Jul 9th, 2015

 

You cannot associate a view with trigger