Auto-Increment ID columns and table truncation
Do AUTO-INCREMENT ID columns reset when a table is truncated? Our table will be trucated regularly but we would like every row to have a unique identifier
0
Do AUTO-INCREMENT ID columns reset when a table is truncated? Our table will be trucated regularly but we would like every row to have a unique identifier
Comments
No. It does not. You can however, reset the sequence by altering it. alter sequence restart with 1.