Unique AND Primary key?

Worker Joined: Jun 06, 2006 Posts: 105

Hello,

I am just wondering if it's possible to have a unique AND primary key'd column in a table?

registered · Posted: Fri Aug 24, 2007 3:29 pm

A primary key is already a unique key.

Posted: Fri Aug 24, 2007 7:03 pm

yes one column can be primary and another unique.
You could even use multiple columns to make a combination primary or unique

Posted: Fri Aug 24, 2007 7:25 pm

Thank you evaders99, that makes total sense.

thank you too djmaze, however I was referring to a SINGLE column of data, not multiples.

Thank you both,

Spyrule.