Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Difference in DELETE and TRUNCATE for IDENTITY

Author  Topic 

learntsql

524 Posts

Posted - 2014-10-20 : 05:30:23
Hi All,

I have a query here.

Why it behaves different for IDENTITY property in DELETE and TRUNCATE.

i.e. when we delete it continues to insert from the last inserted value but for TRUNCATE it re initiate to the seed.

can some one please explain why this is the behaviour.

TIA

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-20 : 08:59:06
That's the way it works in SQL SERVER. See http://msdn.microsoft.com/en-us/library/ms177570.aspx
Go to Top of Page
   

- Advertisement -