-- Check the current database. DBCC CHECKDB; GO -- Check the AdventureWorks2012 database without nonclustered indexes. DBCC CHECKDB (AdventureWorks2012, NOINDEX); GO
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)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)