-- Check the current database.
-- Check the AdventureWorks2012 database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks2012, NOINDEX);
This command is used to reset the identity fields on the table.whenever you delete rows,the identity column will not reset by default.
To reset the identity column,Run the following command:
DBCC CHECKIDENT ('[TestTable]', RESEED, 0)
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)