Skip to content

Instantly share code, notes, and snippets.

@Dillie-O

Dillie-O/sql_reset_autoincrement.sql

Created May 24, 2017 14:40
Show Gist options
  • Save Dillie-O/120287e3cac741c9444db62ad81d09b3 to your computer and use it in GitHub Desktop.
Save Dillie-O/120287e3cac741c9444db62ad81d09b3 to your computer and use it in GitHub Desktop.
Download ZIP
[Reset AutoIncrement Seed] Resets autoincrement column to value needed #tags:sql
Raw
sql_reset_autoincrement.sql
DBCC CHECKIDENT (TABLE_NAME, RESEED, 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment