Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete from a view
> Of course, that's why I wanted to know if there is a way to tell the
> database that column X in the view is a primary key
There is no such way. A view does not have a primary key. PK constraints are applied only on the table level.
Any reason why you can't just delete from the table? Or use an INSTEAD OF trigger?
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Thu Apr 29 2004 - 07:55:59 CDT