If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL notation for combined primary key ??

Elfman · 2006-05-09 13:16:38

CAn any one tell what is the notation for using a combined primary key thanks laods -Elfman

Options

09-05-2006 2:16pm

#1

Elfman

Registered Users Posts: 221 ✭✭

Join Date: February 2005

Posts: 114

CAn any one tell what is the notation for using a combined primary key

thanks laods

-Elfman

0

Comments

Options
#2 09-05-2006 5:10pm
Smoggy

Registered Users Posts: 1,466 ✭✭✭

Join Date: January 2006

Posts: 1205

I dont think there is one ....
Are we talking many - many here ?
In this case I usually form a new PK as a new column, For Orders and Products form a table called Orders_Products and call the PK Orders_Products_PK. If you dont want to do this just leave the Columns as they are as neither one in its own right is the PK.

0