Unique AND Primary key?

spyrule · 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?

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2852

A primary key is already a unique key.

djmaze · 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

spyrule · Worker Joined: Jun 06, 2006 Posts: 105

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.