Subject | Firebird Foreign Key + Unique Constraint ( One/Zero-To-One) |
---|---|
Author | Carlos de Cumont |
Post date | 2012-09-18T13:43:44Z |
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]
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]