On Feb 25, 4:38 pm, clau..._at_wonderworld.com (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
ON DELETE CASCADE is a clause of a foreign key constraint. Constraints
can be specified inline as part of CREATE TABLE (at either column or
table level) or separately with ALTER TABLE ADD CONSTRAINT.
Received on Mon Feb 26 2007 - 07:30:12 CST
