Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Sinapore
    Posts
    187

    Unanswered: Gaps in primary field

    Hi,

    Is it common for gaps (missing column identifiers) to develop in a table that has an auto-increment field used as a primary key, because some rows were deleted over time? Does it matter if this table is referenced by other tables?

    Looking forward to your replies

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, and no, respectively

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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