Results 1 to 3 of 3

Thread: SQL Server - Reinitialize auto-increment values

  1. Mar 25th, 2008, 04:12 PM #1
    dbelley_office
    dbelley_office is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2004
    Posts
    369

    SQL Server - Reinitialize auto-increment values

    Hi,

    I have around 10-15 tables that I want to clear.
    Is there a quick way (in a script) to have the auto-increment field restart at 1 ?

    Thank you.
    Reply With Quote Reply With Quote
  2. Mar 25th, 2008, 05:04 PM #2
    itspramod
    itspramod is offline
    Addicted Member
    Join Date
    Feb 2008
    Location
    California
    Posts
    151

    Re: SQL Server - Reinitialize auto-increment values

    DBCC CHECKIDENT ("tablename", RESEED, 1);
    Reply With Quote Reply With Quote
  3. Mar 27th, 2008, 11:02 AM #3
    CVMichael
    CVMichael is offline
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: SQL Server - Reinitialize auto-increment values

    Or just truncate the table, that will reset the identities... (but that requires more permissions)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width