Column Constraint and PK autoincrement

• bpmosullivan

  Mr or Mrs. 500

  Points: 538

  More actions

  May 18, 2015 at 2:29 pm

  #304111

  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 ?

• Eric M Russell

  SSC Guru

  Points: 125562

  More actions

  May 18, 2015 at 2:32 pm

  #1798838

  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