-3

Delete can continue identity values? how Truncate affects identity values?

vani
  • 1
  • 1
    `truncate table` resets identity values. – Gordon Linoff Apr 11 '21 at 02:57
  • Hi and welcome to StackOverflow! Visit the [help center](https://stackoverflow.com/tour), take a [tour](https://stackoverflow.com/tour) and see [How to Ask a Good Question](https://stackoverflow.com/help/how-to-ask). – Parzival Apr 11 '21 at 03:18

1 Answers1

0

TRUNCATE always removes all the rows from a table, leaving the table empty and the table structure intact whereas DELETE may remove conditionally if the where clause is used. The rows deleted by TRUNCATE TABLE statement cannot be restored and you can not specify the where clause in the TRUNCATE statement

Nederxus
  • 65
  • 1
  • 5
  • So is there any way you can find the data back after you delete it? YOu cannot trace it back after you truncate it, can you? – vani Apr 11 '21 at 04:21