Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL: DELETE and DROP TABLE with cascading ?
Claudia d'Amato wrote:
> As far as I found out DELETE and DROP TABLE are NOT possible with some kind of
> additional cascading instruction.
>
> DELETE CASCADE
> FROM mytable
> WHERE ....
>
> is not possible.
> Same with:
>
> DROP TABLE mytable CASCADE
>
> The only way I found so far is that I have to specify a clause
> "ON DELETE CASCADE" at the time when the table(s) were created.
>
> Is this really true?
>
> Is there no work around to pass an explicitly "get rid aff the whole table structure/records"
> at the time of deletion regardless of wether an ON DELETE CASCADE is specified before or not ?
>
> Claudia
Correct.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Feb 25 2007 - 14:57:22 CST