reset identity colum in SQL Server

On SQL Server, to reset an identity column we can use the DBCC CHECKIDENT (that checks the current identity value for the specified table in SQL Server and, if it is needed, changes the identity value). The syntax for the command is the following: For example, if we have a table called ‘TABLE_NAME’, to reset the […]