1
Reply

If we update the view will it automatically update main table?? Also vice versa is possible to update ??

sathish

sathish

May 11, 2011
10.5k
0

    Updating a view will also update its underlying table on following conditions-

    1. Atleast one column of View is a primary key
    2. The view has been created from a single table only.
    3. View does not contain any null fields of the underlying  table.
    4. It should contain only unique records.
    5. Lastly, query to create the view should not contain any "group by" field.
    As for the latter part of your question, a view is a virtual table , it is reflection of content of its underlying table, so any updation to base table will naturally update the view.

    I hope this solves your query.

    Thanks,
    Tanima

    tanima
    May 16, 2011
    0