Composite Key

• kaladharreddy15

  SSC-Addicted

  Points: 476

  More actions

  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

• mithun.gite

  SSCrazy

  Points: 2333

  More actions

  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