Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: identity columns

    Can some one provide some guidelines on when to use identity columns, the advantages, pros and cons to consider...etc
    When and how would it be useful to use indentity columns?

    Also..if such a column is used, are there any pitfalls, if uniqueness is enformed on another set of columns in the same table by means of a unique index?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    the favour is that you don't need to care about primary key values; they are automatically incremented. If you had a table for the high watermarks you may run in (dead)lockings if the hit rate ist high

    for the cons and pitfalls look at rob verschoor's site at

Posting Permissions

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