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

adamfoxadamfox
in General Discussion

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

  • kaurorakaurora

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

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