Column Constraint and PK autoincrement

  • running an insert into a table where a column has a constraint for unique records

    i have an autonumber pk that increments but numbers are not in sequence etc. if constraints are found

    e.g.

    10 records are inserted but only 2 are unique but there is a gap of 8 in the PK autoincrement value (it's like the unique records that were not inserted are still being recorded by the autoincrement)

    Any way around this ?

  • Post DDL for the table, including the constraints, defaults, and indexes. Also the insert statement.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply