Subject | Re: [Firebird-Java] How to turn referential integrity checking off |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-09-30T06:27:31Z |
> All these cases can be addressed by the simple expedient of declaring aIf application developer has names of all foreign keys, it no longer matters
> foreign key inactive.
what to execute:
ALTER TABLE <table name> ALTER CONSTRAINT <foreign key name> INAVTIVE;
or
ALTER TABLE <table name> DROP CONSTRAINT <foreign key name>
The talk is about a global switch that triggers all constrains inactive
without a need to walk through all system tables and deactivating each
constraint separately.
Roman