Checks an IDENTITY column's current value and resets its seed. In Fabric Data Warehouse only plain RESEED is allowed (you can't give it a new value), and you should run it once IDENTITY_INSERT loads have finished.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DBCC CHECKIDENT in context, with comparison tables and the common traps.
Terms in this definition
- Identity column
Assigns a unique
BIGINTto every row inserted into a Delta table, though not always in an unbroken sequence; it is declared asGENERATED ALWAYS AS IDENTITYorGENERATED BY DEFAULT AS IDENTITY. Concurrent writes are disabled and a rebuild can change the numbers, so it suits append-only tables that no full refresh will ever touch. - Warehouse
Fabric item offering complete T-SQL support (DML, DDL, multi-table transactions) over Delta tables held in OneLake; lakehouse SQL analytics endpoints, by contrast, are read-only.
- IDENTITY
A column property, written IDENTITY(seed, increment), that gives each new row the next number in a rising sequence. SCOPE_IDENTITY reports the latest value created in the current scope, and a rolled-back transaction still uses up the numbers it took.
- INSERT
Adds fresh rows to a table. You list the target columns and supply a value for each; it is part of Data Manipulation Language (DML).