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:

Hope is the moonlight filtering through the trees,Hope is the silent prayer that we make in distress,Hope is the promise that we make to ourselves,Hope is the happiness that we visualize, Hope is the horizon that we reach, if we try!
-Balroop Singh