Identity field as primary key

Results 1 to 3 of 3

Thread: Identity field as primary key

  1. #1
    MnM Guest

    Default Identity field as primary key

    Should I use an identity field for a relational primary key?<BR>What if one of my indentity fields in my relational database <BR>gets renumbered? Then I have lost all my relations.<BR><BR>M

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Identity field as primary key

    and why and how will you renumbered an identity col??

  3. #3
    RipCat Guest

    Default RE: Identity field as primary key

    I use identity fields all the time as primary keys...It works really good and you don&#039t have to worry about uniqueness...<BR><BR>The only way to renumber an identity is to take identity property off...If you ever were to do...I would hope you had A VERY GOOD reason to...And...Would take into account change ramifications...<BR><BR>Once an identity assigns a value, you can&#039t renumber unless you do above or delete field (be wary of) and readd...<BR><BR>So...Hope this helps...<BR><BR>RipCat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts