User Id :    Password :      New Member   Forgot Password  
Topic: Can we have an updateable view in SQL
Anamika singh
20 Oct 2010 at 02:56 AM
Can we have an updateable view in SQL?
Re: Can we have an updateable view in SQL
22 Oct 2010 at 10:55 PM

There are two types of views namely Simple and complex views.

You can perform DML operation on simple views which is based on single table and that view doesn't contain any single row function and any group by clause and it has to satisfy integrity constraint also.

You can't perform DML operation on complex views because they are based on multiple tables. U can achieve this task by using Triggers (Instead of...) INSTEAD OF triggers describe how to perform insert, update, and delete operations against views that are too complex to support these operations natively.

Total Replies: 1
Featured Text Ad

Featured Ad