|Subject||RE: [Firebird-Java] How to turn referential integrity checking off|
> There are no trigger, it is checked by the corresponding indexI don't understand. There is a unique index on the parent's columns,
and a non-unique index on the child's columns. Something must run to
confirm that the value added/updated in the child exists in the parent's
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of Roman Rokytskyy
Sent: Friday, September 30, 2005 12:12 PM
Subject: Re: [Firebird-Java] How to turn referential integrity checking
> ALTER TABLE <table name> ALTER CONSTRAINT <foreign key name> INAVTIVESure, this construct does not exist yet, but maybe Jim adds it in Vulcan
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> 37 CONSTRAINT
> Although it might be implemented by turning off the trigger thatThere are no trigger, it is checked by the corresponding index... which
> enforces it.
cannot be deactivated. So for now you can only drop constraint.
Yahoo! Groups Links