ainpoissee wrote:

>Hi!
>
>Am I correct that current ALTER TABLE syntax doesn't support adding
>"ON DELETE CASCADE" to existing FK (ie I have to create new FK field,
>move data over and drop old fileld to achieve this)?
>
>TIA
>ain
>
>
>

No,

Drop the constraint, create the new constraint with delete cascade option.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 22/09/2005