What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 18980 Views
- CTS, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are “phantom rows”?
What is the use of floor function in sql server?
What are the 7 disadvantages to a manual system?
How to select some specific columns from a table in a query in ms sql server?
what are user defined datatypes? : Sql server database administration
Write a sql query to sort on different column name according to the parameters passed in the function?
What stored by the model? : sql server database administration
what is the difference between delete table and truncate table commands? : Sql server database administration
What is inline table-value user-defined function?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How to find the second highest salary of an employee?
How to use go command in "sqlcmd"?
Which sql server is best?
What happens if an integer is too big for int date type?
Can coalesce return null?
