Subject Re: [firebird-support] Alter table - how to add ON DELETE CASCADE
Author Alexandre Benson Smith
ainpoissee wrote:

>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)?

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

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

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