How to reset the identity column in SQL Server?

Options :
  1. DBCC CHECKIDENT (''tableName'', RESEED, 1)
  2. DBCC RESET (''tableName'', RESEED, 1)
  3. RESET IDENTITY(''tableName'', RESEED, 1)
  4. TSQL CHECKIDENT (''tableName'', RESEED, 1)

Answer and Explanation :-

Answer: Option 1


You can reset the identity column using TSQL using below TSQL. DBCC CHECKIDENT ('tableName', RESEED, 1) In above example order is the table name and 1 is the next insert record id

How do you rate this queston?  Very Easy  Easy  Average  Above Average  Tough

Next Question : What is the use of Count_Big() function in SQL Server

Click here for free online test on SQL Server


 (Getemail alerts when others member replies)

More available Categories:

You can learn more in half an hour's direct contact with a source of knowledge (no matter the apparent reason for the contact or the subject of the transaction) than you can in years of formal effort.
-Idries Shah Learning How to Learn: Psychology and Spirituality in the Sufi Way