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 online test on SQL Server

More available Categories:-


 (Getemail alerts when others member replies)

In our world," said Eustace, "a star is a huge ball of flaming gas."Even in your world, my son, that is not what a star is, but only what it is made of.
-C.S. Lewis The Voyage of the Dawn Treader