Auto_Increment
Posted by:
Jim Sawyer
Date: April 03, 2018 08:04AM
Assume you have a table with an auto_increment primary key. Assume you have 100 records in the table such that the highest primary key value is 100. Then assume that for whatever reason you delete that last record. When the next record is later added, will the primary key value of 100 be skipped or will it be repeated since the old record with 100 was deleted?
Thanks,
Jim Sawyer
Subject
Written By
Posted
Auto_Increment
April 03, 2018 08:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.