Re: unique and primary constraints

2001-06-24 Thread Ansgar Becker
> if i set a field as a primary key, does it automatically make sure its > unique or should i declare a UNIQUE constraint as well? or will primary do > the job by itself. a primary key is always unique. No need to give it an extra unique index. Greetings, Ansgar http://www.mysqlfront.de/ ---

unique and primary constraints

2001-06-24 Thread Aek
hi sql ppls, if i set a field as a primary key, does it automatically make sure its unique or should i declare a UNIQUE constraint as well? or will primary do the job by itself. thanks - Josh [EMAIL PROTECTED] - Before pos