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


  • No. It does not. You can however, reset the sequence by altering it. alter sequence restart with 1. 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file