Delete doesn't reset identity column seed if you have 1 identity colu

What is difference between TRUNCATE and DELETE statement

Question Posted / monal

Answer Posted / monal

Delete doesn't reset identity column seed if you have 1
identity column in the table.
Truncate resets identity column seed to the original value.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to define and use table alias names in ms sql server?

1042

What are some examples of schemas?

909

explain what is raid and what are different types of raid configurations? : Sql server database administration

949

What are the advantages to use stored procedures?

1032

Can you insert NULL in unique column?

1094

What are various aggregate functions that are available?

914

Explain the advantages of merge replication?

894

What is the synonym of join?

895

Which tcp/ip port does sql server run on? How can it be changed?

976

do views contain data ?

911

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

844

What does ss stand for sexually?

1009

How to create a dynamic cursor with the dynamic option?

969

What are “phantom rows”?

1608

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1166