Carlos, > 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 !
Vote for it: http://tracker.firebirdsql.org/browse/CORE-651 -- With regards, Thomas Steinmaurer http://www.upscene.com/
