Top Posts Tagged with #reset identity

SQL Delete

SQL Delete and reset identity

Why

We all have to delete data from tables from time to time, and sometimes we want to reset the Identity column, this can be achieved like this:

Theory

The DBCC CHECKIDENT management command is used to reset identity counter.

The command syntax is:

DBCC CHECKIDENT (table_name [, { NORESEED | { RESEED [, new_reseed_value ]}}]) [ WITH NO_INFOMSGS ]

Example

DELETE FROM [table_name] DBCC CHECKIDENT ('[table_name]', RESEED, 0); GO

#SQL #Delete #Reset identity #CHECKIDENT

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming