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

Explanation:

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

Responses


 (Getemail alerts when others member replies)

More available Categories:-








When my income exceeds my outgo, my upkeep will be downright easy.
-Cynthia Sue Larson Realityshifters Guide to High Energy Money