Post reply

Composite Key

  • February 8, 2009 at 9:04 pm

    #218366

    Hi Friends,

    I have two columns like IntakeID [int], NOT NULL and PlacementID (PK) [int], NOT NULL

    How to make composite key addind IntakeID and Placement

    Thanks in Advance

    kala

  • February 8, 2009 at 9:43 pm

    #940260

    hi,

    is is as simple as ur create the primary key.

    ALTER TABLE dbo.Table_1 ADD CONSTRAINT PK_Table_1 PRIMARY KEY (id, name)

    replace table name and column names as per ur comfort...

    mithun

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply