ainpoissee wrote:

>Hi!
>
>Am I correct that current ALTER TABLE syntax doesn't support adding
>"ON DELETE CASCADE" to existing FK
>

Yes. That operation is not supported.

>(ie I have to create new FK field,
>move data over and drop old fileld to achieve this)?
>
>
>
>

Why not drop the constraint and create it again in the correct
form? I can't see a reason for a new field and a data move here.

Ivan.