Surrogate Key Vs Foreign Key

• santhosh_ms3

  Default port

  Points: 1482

  More actions

  September 27, 2011 at 12:28 am

  #245423

  Hi,

  I have a child table(C) which has the composite primary key(A1+B1) from Table A and B.

  Now i want to create a surrogate key in table C which should be a foreign key for another table D.

  Is it possible, to reference a non primary key as foreign key to another table?

  Regards,

  Santhosh.

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  September 27, 2011 at 3:21 am

  #1386991

  You can reference a unique constraint when making a foreign key. It's that or a primary key.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning