Subject | Re: [Firebird-Java] How to turn referential integrity checking off |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-09-30T16:11:38Z |
> 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.