Re: UPDATE or INSERT on a view ?

From: andrewst <member14183_at_dbforums.com>
Date: Mon, 22 Sep 2003 09:13:44 -0400
Message-ID: <3398958.1064236424@dbforums.com>

Originally posted by Zixiong Wang

> Hi,

> Can I execute an UPDATE or an INSERT to a view ?

> Thanks,

> --

> z.wang_at_sysium.com

Yes, you can (and DELETE too) - subject to some restrictions on key-preserved columns only, and not for views based on DISTINCT, GROUP BY etc.

Even for those cases, you can use an INSTEAD OF trigger to make the view effectively updateable.

--
Posted via http://dbforums.com

Received on Mon Sep 22 2003 - 08:13:44 CDT