tsql reseed identity USE AdventureWorks2012; GO DBCC CHECKIDENT (‘Person.AddressType’, RESEED, 10); GO

what is a trigger in sql — Azure SQL Database Syntax — Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger) CREATE [ OR ALTER ] TRIGGER [ schema_name . ]trigger_name ON { table | view } [ WITH <dml_trigger_option> [ ,…n ] ] { FOR | AFTER | […]