Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones IDENTITY_INSERT RE: IDENTITY_INSERT
Richard Barber
Newbie
Points: 9
More actions
January 26, 2009 at 8:02 pm
#932965
Does anybody else but me think that Order_details is designed wrongly? OrderID should be a foreign key to Orders.OrderID. The natural key of Order_Details is OrderID and LineItemID which does not require an IDENTITY column at all.;)