Subject Firebird Foreign Key + Unique Constraint ( One/Zero-To-One)
Author Carlos de Cumont
Hello.

Is it possible to combine a Foreign Key + a Unique Constraint to avoid
duplicate index ?

ALTER TABLE SVCs_Batch ADD
CONSTRAINT RF_SVCs_Batch2XDRs_Batch
FOREIGN KEY (Id_XDRs_Batch) REFERENCES XDRs_Batch(Id_XDRs_Batch)
using *UNIQUE* index FK_SVCs_Batch_XDRs_BATCH;

this is not (yet) accepted !

Thank you for your assistance,

Carlos


[Non-text portions of this message have been removed]