Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.