Re: [firebird-support] Order of key elements

2012-10-16 Thread Ann Harrison
On Mon, Oct 15, 2012 at 12:09 PM, Rick Debay rde...@accessrxs.com wrote: What is the effective difference between these two key elements orderings? ALTER TABLE T ADD CONSTRAINT U UNIQUE (PK, HIGH_MAX_DUP) ALTER TABLE T ADD CONSTRAINT U UNIQUE (HIGH_MAX_DUP, PK) The first version is how I

[firebird-support] Order of key elements

2012-10-15 Thread Rick Debay
What is the effective difference between these two key elements orderings? ALTER TABLE T ADD CONSTRAINT U UNIQUE (PK, HIGH_MAX_DUP) ALTER TABLE T ADD CONSTRAINT U UNIQUE (HIGH_MAX_DUP, PK) The first version is how I normally order key elements, from most unique to least. Since a primary key