RE: PRIMARY KEY (userid), UNIQUE (userid)

2001-02-07 Thread Cal Evans
Yes, you can but you probably need a real good reason to. As Tilghman pointed out a PK is a unique key. If you have another unique key (a candidate key) then you need revisit your datamodel and make sure you have a good reason. Candidate keys to exist in the real world but they are rare. Cal htt

RE: PRIMARY KEY (userid), UNIQUE (userid)

2001-02-07 Thread The Tilghman
No. A primary key is a unique key, by definition. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 09:58 > To: [EMAIL PROTECTED] > Su