surrogate key?

• Rachell-76794

  Ten Centuries

  Points: 1067

  More actions

  February 25, 2004 at 7:24 am

  #161032

  I read some info for dimensition table we better add surrogate key, I checked everywhere do you know how I can add it?

  Thanks

  
  Rachel

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  February 25, 2004 at 4:59 pm

  #495717

  A surrogate key (in contrast to a natural key) is an artificial key, it could simply be a column with the IDENTITY property.

  HTH

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA