Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: change primery key

  1. 12-05-2009, 04:36 AM #1
    r_bachar is offline Junior Member
    Join Date
    Nov 2009
    Posts
    23

    Default change primery key

    is it possible to define the SKU of a product as a primary key instead of the productID, in the product table?
  2. 12-06-2009, 06:01 PM #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Well, yes, but that would require modification on most of the projects, tables, SQL user-defined functions, stored procedures, etc., considering that the store takes the ProductID as the primary and then the SKU as the secondary...