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
Auto-Increment ID columns and table truncation
No. It does not. You can however, reset the sequence by altering it. alter sequence restart with 1.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
