1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to declare two primary keys in a table?

Discussion in 'Databases' started by rajanrufus, Aug 27, 2013.

0
  1. #1
    Hai,
    After a long time i have came back to this forum and brought a question for you all guys.
    Actually i am learning sql of my own and doing exercises in it. Now i have to know that 'How to declare two primary keys in a table?'

    Thank you,
     
    rajanrufus, Aug 27, 2013 IP
  2. felomeno

    felomeno Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    It would be better if you tell me what do you need to do with the two primary keys... but, this should do it

    alter table TABLE_NAME add constraint PK_KEY_NAME primary key nonclustered (Column1,Column2)
    Code (markup):
    Column1 and Column2 will be added as primary keys.
    Hope it helps. ;)
     
    felomeno, Aug 27, 2013 IP