Patricio Treviño

Patricio Treviño

Husband . Father . Developer
1total entries in column

Reset an identity column of a table in SQL Server

Syntax

DBCC CHECKIDENT (<table>, RESEED, <value>)
view raw syntax.text hosted with ❤ by GitHub

Option Description
table The name of the table to be reset.
value The new value to be used.