DBCC CHECKIDENT(‘TableName’, RESEED, 0) Note that after running DBCC CHECKIDENT(‘TableName’, RESEED, 0): – Newly created tables will start with identity 0 – Existing tables will continue with identity 1
Tag: reset
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (705)
- Get the First and Last Word from a String or Sentence in SQL (698)
- How to select distinct rows in a datatable in C# (560)
- Add Constraint to SQL Table to ensure email contains @ (455)
- Average of all values in a column that are not zero in SQL (373)