SQL Server - Online Test

Total Number of Questions in this Test: 10
Total Number of Questions Answered: 0
Total Number of Questions Skipped: 0


Time left:
 
Question : 1

How to reset the identity column in SQL Server?

Options :
  •  DBCC CHECKIDENT ('tableName', RESEED, 1)
  •  DBCC RESET ('tableName', RESEED, 1)
  •  RESET IDENTITY('tableName', RESEED, 1)
  •  TSQL CHECKIDENT ('tableName', RESEED, 1)